different fields in v$sqlarea

From: <ryan.gaffuri_at_cox.net>
Date: Wed, 26 May 2004 10:06:21 -0400
Message-Id: <20040526140621.UNDZ10019.lakermmtao05.cox.net@smtp.east.cox.net>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed May 26 2004 - 09:03:16 CDT