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