Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Session_wait

RE: Session_wait

From: <Cherie_Machler_at_gelco.com>
Date: Mon, 28 Jan 2002 09:10:39 -0800
Message-ID: <F001.003FD4FE.20020128082530@fatcity.com>

John,

Thanks for this interesting analysis. I learned a lot from it.

Cherie Machler
Oracle DBA
Gelco Information Network

                                                                                       
                           
                    John Kanagaraj                                                     
                           
                    <john.kanagara       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>      
                    j_at_hds.com>           cc:                                           
                           
                    Sent by:             Subject:     RE: Session_wait                 
                           
                    root_at_fatcity.c                                                     
                           
                    om                                                                 
                           
                                                                                       
                           
                                                                                       
                           
                    01/25/02 06:35                                                     
                           
                    PM                                                                 
                           
                    Please respond                                                     
                           
                    to ORACLE-L                                                        
                           
                                                                                       
                           
                                                                                       
                           




Sergey,

My $0.02 below: (comments below and only for relevant stats, some of which have been re-arranged):

NAME                                                                  VALUE
----------------------------------------------------------------  ---------
opened cursors cumulative                                              1072
opened cursors current                                                   11

user calls                                                              341
recursive calls                                                      198492
recursive cpu usage                                                    4089
CPU used by this session                                             696253

enqueue requests                                                      11878
enqueue releases                                                      11876

session logical reads                                              77233609
= db block gets + consistent gets
db block gets                                                       2642119
consistent gets                                                    74591490
physical reads                                                       148822
db block changes                                                    3005410
consistent changes                                                      141
redo entries                                                        1506007
redo size                                                         1.184E+09
= approx 1.1 Gb!!!
physical writes                                                        2728
physical writes non checkpoint                                         2728

physical reads direct                                                  3594
physical writes direct                                                 2728

table scans (short tables)                                           210918
table scans (long tables)                                                36
table scan rows gotten                                            798264962
table scan blocks gotten                                           71788386
table fetch by rowid                                                1074164
table fetch continued row                                                12

leaf node splits                                                       4018
branch node splits                                                        9

Having said all that above, I hazard the following guesses:

Perform a trace and TKPROF it. If you post the output, we could help further. My feeling is that 'Database' or 'Instance' level tuning via init parameters isn't going to get you much mileage. However, SQL tuning certainly will!

Have a nice weekend, all!

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Fear is the darkroom where Evil develops your negatives. Wanna break free of fear? Click on 'http://www.needhim.org'

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Cherie_Machler_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Jan 28 2002 - 11:10:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US