Re: Is this too many?
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: "oralrnr@xxxxxxxxx" <oralrnr@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Apr 2014 11:24:41 -0700 (PDT)
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@xxxxxxxxx> 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.
Other related posts:
