Home » RDBMS Server » Performance Tuning » Regarding v$librarycache
Regarding v$librarycache [message #198902] Thu, 19 October 2006 01:47 Go to next message
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
Re: Regarding v$librarycache [message #198958 is a reply to message #198902] Thu, 19 October 2006 05:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Regarding v$librarycache [message #198963 is a reply to message #198902] Thu, 19 October 2006 06:50 Go to previous messageGo to next message
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
Re: Regarding v$librarycache [message #198964 is a reply to message #198963] Thu, 19 October 2006 07:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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

Re: Regarding v$librarycache [message #198973 is a reply to message #198902] Thu, 19 October 2006 08:14 Go to previous messageGo to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
It is reloads value against namespace='SQL AREA'
Re: Regarding v$librarycache [message #199812 is a reply to message #198902] Thu, 26 October 2006 05:34 Go to previous message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Please help me on the below mentioned
Previous Topic: Help Deciding on Local or Global Index
Next Topic: Update vs CTAS
Goto Forum:
  


Current Time: Sun Dec 04 16:37:27 CST 2016

Total time taken to generate the page: 0.12360 seconds