| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Shared Pool Wait while using SQL Loader
You queried everything from v$session_wait and you needed to query only
the information relevant to the SID that is waiting. Other then that,
the only session in "WAITING" status is waiting for a lock. Your chase
is about to continue. Now that you have lock address, go on your way
to v$lock table, grasshopper. The legend continues.
On 2003.07.08 21:29, "Chindarkar, Chetan (CONS FIN , Contractor)" wrote:
Gurus ,
We run a Oracle 8.1.7.4.0 dw on Sun Solaris 2.8 version and its a data
warehouse environment. There are lots of SQL Loader jobs which run on a
day-to-day basis.
Normally it takes 15-20 mins to finish the loading but today it is taking
more than an hour and nothing seems to happen. This is a range partitioned
table.
Here are the results of the queries on v$ views.
SID SEQ# EVENT
---------- ----------
P1TEXT P2TEXTSECONDS_IN_WAIT STATE
----------------------------------------------------------------
----------------------------------------------------------------
P3TEXT WAIT_TIME
113 9126 db file sequential read
file# block#
blocks -1
0 WAITED SHORT TIME
86 2404 db file scattered read
file# block#
blocks 2
0 WAITED KNOWN TIME
8 7539 smon timer
sleep time failed
0
232 WAITING
70 36 SQL*Net message to client
driver id #bytes
-1
0 WAITED SHORT TIMEhandle address
3830864540 E4565A9C
lock address 4121106472
F5A31828
10*mode+namespace 31
0000001F 0 677 WAITING
70 32 SQL*Net message to client
driver id 1650815232
62657100
#bytes 1
00000001
0
00 -1 0 WAITED SHORT TIME
Please advise ...
 |
 |