OraFAQ Forum: Performance Tuning » gets,pins and reloads in v$library Cache

Home » RDBMS Server » Performance Tuning » gets,pins and reloads in v$library Cache

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

gets,pins and reloads in v$library Cache [message #358289]

Mon, 10 November 2008 09:55

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

Report message to a moderator

Re: gets,pins and reloads in v$library Cache [message #358392 is a reply to message #358289]

Tue, 11 November 2008 01:43

ankush_chawla
Messages: 136
Registered: November 2006

Senior Member

please response. I know its basics . But it will take 2 mins from an expert.

Report message to a moderator

Re: gets,pins and reloads in v$library Cache [message #358398 is a reply to message #358392]

Tue, 11 November 2008 02:07

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	SESSION CPU
Next Topic:	Wait events

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 07:36:16 CST 2025