Is this too many?
- From: Orlando L <oralrnr@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Apr 2014 12:41:46 -0500
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:
