OraFAQ Forum: Performance Tuning » Gets and GetHits difference ?

Home » RDBMS Server » Performance Tuning » Gets and GetHits difference ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Gets and GetHits difference ? [message #402404]

Sat, 09 May 2009 23:50

tridentadm
Messages: 142
Registered: March 2006

Senior Member

I was referring :

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm

--
For v$librarycache :

GETS NUMBER Number of times a lock was requested for objects of this namespace
GETHITS NUMBER Number of times an object's handle was found in memory

Q. Can someone differentiate what this two mean ?
Is it like GETS is the request made for the object and if its in the librarycache then its a incremental counter for GETHITS.
While if its not there then GETS would be a hard-parse

Also I believe that PINS is different from the above two.

Q. When would a GETS be there but not a PINS ?

Report message to a moderator

Re: Gets and GetHits difference ? [message #402406 is a reply to message #402404]

Sat, 09 May 2009 23:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You chose to ignore Posting Guideline, so we chose to not answer.

Report message to a moderator

Re: Gets and GetHits difference ? [message #402409 is a reply to message #402406]

Sun, 10 May 2009 00:12

tridentadm
Messages: 142
Registered: March 2006

Senior Member

I did give reference for my question.

I dont know what posting guidelines to follow ?

[Updated on: Sun, 10 May 2009 00:17] by Moderator

Report message to a moderator

Re: Gets and GetHits difference ? [message #402410 is a reply to message #402404]

Sun, 10 May 2009 00:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

Report message to a moderator

Previous Topic:	Query "Statements run in past 24 hrs with execution time"
Next Topic:	Regarding AWR report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 00:38:13 CDT 2024