Home » RDBMS Server » Performance Tuning » gets,pins and reloads in v$library Cache
gets,pins and reloads in v$library Cache [message #358289] Mon, 10 November 2008 09:55 Go to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
hello

I know there are many documents explaining the above. However i get confused with pins and gets .
Pins are finding the parsed version of the SQL statement.
Reloads are reloading of objects into memory which might be invalidated due to change in structure .
Kindly explain them in detail and how they affect the performance.

Regards
Re: gets,pins and reloads in v$library Cache [message #358392 is a reply to message #358289] Tue, 11 November 2008 01:43 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
please response. I know its basics . But it will take 2 mins from an expert.
Re: gets,pins and reloads in v$library Cache [message #358398 is a reply to message #358392] Tue, 11 November 2008 02:07 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Unfortunately, I wouldn't know the answer.

But I suppose it must be very trivial if someone can explain these terms in details and the way they affect the performance in only 2 minutes.
Previous Topic: SESSION CPU
Next Topic: Wait events
Goto Forum:
  


Current Time: Fri Dec 09 13:58:34 CST 2016

Total time taken to generate the page: 0.07311 seconds