Re: Is this too many?

From: David Fitzjarrell <>
Date: Thu, 3 Apr 2014 11:24:41 -0700 (PDT)
Message-ID: <>

I think not.  You're running a packaged application with 'canned' queries and multiple users accessing the database at any one time.  Also your granularity is a bit small (the entire day) so the numbers will be rather large.  If you ran the query against the full date string rather than a portion of it the numbers would be much smaller.  FIRST_LOAD_TIME is the date/time the cursor was first loaded (parsed) and won't be updated until that cursor ages out of the SQL area; LAST_LOAD_TIME more accurately reflects the date/time of the last reload of that cursor.   David Fitzjarrell Primary author, "Oracle Exadata Survival Guide" On Thursday, April 3, 2014 12:01 PM, Orlando L <> wrote: List At 11am apr03 in one of our prod dbs:  SQL> select * from     2   (select count(*), substr( FIRST_LOAD_TIME, 1 , 10) from v$sqlarea    3     group by substr( FIRST_LOAD_TIME, 1 , 10) order by 2 desc ) where rownum < 20;   COUNT(*) SUBSTR(FIR ---------- ----------       5415 2014-04-03         20 2014-04-02          6 2014-04-01  ... and on the other node (2 node RAC) the count for the day is close to 4000.  5000 cursors loaded in a span of 11 hours. Is this too much?   This is a peoplesoft fin application. db10.2. sga target is 6G TIA.
Received on Thu Apr 03 2014 - 20:24:41 CEST

Original text of this message