different fields in v$sqlarea
- From: <ryan.gaffuri@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 26 May 2004 10:06:21 -0400
Is buffer_gets the same thing as 'consistent gets' in autotrace outputs? Its
how many latch gets oracle takes on the buffer cache?
I've read the docs, but what is 'sort', and the difference between
'sharable_mem', persistent_mem, and runtime_mem?
Also the difference between a child and parent cursor is simply that the parent
cursor is the hard parsed cursor and each 'child' cursor gets generated every
time a soft parse takes place(when a different value in a bind variable is
submitted). Is that correct?
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » different fields in v$sqlarea
