Home » RDBMS Server » Performance Tuning » Gets and GetHits difference ?
Gets and GetHits difference ? [message #402404] Sat, 09 May 2009 23:50 Go to next message
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 ?

Re: Gets and GetHits difference ? [message #402406 is a reply to message #402404] Sat, 09 May 2009 23:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You chose to ignore Posting Guideline, so we chose to not answer.
Re: Gets and GetHits difference ? [message #402409 is a reply to message #402406] Sun, 10 May 2009 00:12 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Query "Statements run in past 24 hrs with execution time"
Next Topic: Regarding AWR report
Goto Forum:
  


Current Time: Tue Dec 10 02:39:16 CST 2024