Re: Is this too many?
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Thu, 3 Apr 2014 11:24:41 -0700 (PDT)
Message-ID: <1396549481.61338.YahooMailNeo_at_web124703.mail.ne1.yahoo.com>
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 <oralrnr_at_gmail.com> 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.
Date: Thu, 3 Apr 2014 11:24:41 -0700 (PDT)
Message-ID: <1396549481.61338.YahooMailNeo_at_web124703.mail.ne1.yahoo.com>
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 <oralrnr_at_gmail.com> 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 03 2014 - 20:24:41 CEST