-
does every sql goes to v$sqlarea existing there forever?
or they may aged out sometime?
-
the sql you see in v$sqlarea are the sql statments in library cache, therefore they can be there but after sometime they may not be there
-
As long as the statement is in the shared pool, it shows up in V$SQLAREA. They will get aged out subject to the LRU algorithm used by Oracle to manage the shared pool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|