Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Library cache

 
   Database Forums (Home) -> Oracle -> Server RSS
Next:  SQL Transaction across two database server  
Author Message
Chintu

External


Since: Jan 29, 2006
Posts: 1



(Msg. 1) Posted: Wed Feb 15, 2006 5:59 am
Post subject: Library cache
Archived from groups: comp>databases>oracle>server (more info?)

Below is an extract from Performance Tuning Docs pg 14-21

"If an application makes an execute call for a SQL statement, and if
the executable
portion of the previously built SQL statement has been aged out (that
is,
deallocated) from the library cache to make room for another statement,
then Oracle
implicitly reparses the statement, creating a new shared SQL area for
it, and
executes it"

1. >>If an application makes an execute call for a SQL statement, and
if the executable
>>>>portion of the previously built SQL statement

What is this executable portion of a sql Statement? Does it mean that
we have a SQL Statement and some Executable version of the query in
Library cache ??
2. Does the above extract means that we have the sql statement in the
library cache, but
the executable version is aged out ?? In waht situations is it
possible. ??

Thanks
Chintu

 >> Stay informed about: Library cache 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
External library not being pinned in cache... - Hi, all. Running 9i (don't have a version number) on Solaris. A stored procedure is calling an external C library. I'm looking to confirm whether or not this C library is being held in memory after it's called. The user is theorizing that it is not,..

intermittent library cache pin/lock problems - We are seeing intermittent library cache pin/lock problems. The problem occurs for about a min and then goes away. This of course causes timeouts all over the place. Any clue on where to start? We generally have use bind variables.. Relevant settings ...

Cache Hit Ratio from system views - We have acquired a software package that sends alerts based on defined thresholds and/or events. We are working on a simple alert like when the cache hit ratio falls below a given threshold. The package came with a query that uses the..

V$SESSION cache buffers chains latch row_wait columns 10g - I haven't seen this documented anywhere, but it looks like the row_wait* columns in v$session show you which block a latch is on when you have a cache buffers chains latch in 10g. Here is the query I'm using: SELECT s.P1raw..

two schemas and running a diff on stored procedures - Let's say I have two schemas in a database. Both with the same stored procedures however one had some updates made to it. Is there an easy way to see what the differences are between the two schemas as far as the stored procedures without taking them..
   Database Forums (Home) -> Oracle -> Server All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]