OraFAQ Forum: Performance Tuning » Regarding v$librarycache

Home » RDBMS Server » Performance Tuning » Regarding v$librarycache

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

Regarding v$librarycache [message #198902]

Thu, 19 October 2006 01:47

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

I execute a statement select * from emp and then reexecute it a no. of times. Every time i execute , i check the values in sqlarea in v$librarycache... The reloads is increased by one. Can anyone explain why this is happening?

Thanks
reena

Report message to a moderator

Re: Regarding v$librarycache [message #198958 is a reply to message #198902]

Thu, 19 October 2006 05:52

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> i check the values in sqlarea in v$librarycache
Please rephrase. you mena v$librarycache.sqlarea?
There is no such column.

>>The reloads is increased by one.
Becuase the object defintion was "flushed" away and reloaded.
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1143.htm#sthref3711
Next time, Please post your exact oracle version.

Report message to a moderator

Re: Regarding v$librarycache [message #198963 is a reply to message #198902]

Thu, 19 October 2006 06:50

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

Mahesh,

I checked the row with namespace as sqlarea. The reloads are increased by 1 upon reexecution. Why are they flushed away and reloaded as no other activity is performed??How can i avoid that??

Thanks
Reena

Report message to a moderator

Re: Regarding v$librarycache [message #198964 is a reply to message #198963]

Thu, 19 October 2006 07:04

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Usually it is because of insufficient shared pool.

Edit:
Nope.
I am talking about v$librarycache.reloads value
are you talking about v$librarycache.namespace value getting incremented?

[Updated on: Thu, 19 October 2006 07:30]

Report message to a moderator