I forgot to add:
-bash-3.00$ cat nadesico_ora_25481.trc
/opt/Oracle/oracle/product/10.2.0/db_1/admin/nadesico/udump/nadesico_ora_25481.trc
Oracle Database 10g Release 10.2.0.1.0 - 64bit Production
ORACLE_HOME = /opt/Oracle/oracle/product/10.2.0/db_1/
System name: SunOS
Node name: hermes
Release: 5.10
Version: Generic
Machine: sun4u
Instance name: nadesico
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 25481, image: oraclenadesico_at_hermes
- 2005-11-13 16:16:28.828
- SERVICE NAME:(SYS$USERS) 2005-11-13 16:16:28.827
- SESSION ID:(150.62) 2005-11-13 16:16:28.827
PARSING IN CURSOR #9 len=51 dep=0 uid=52 oct=3 lid=52 tim=649035954915
hv=516230619 ad='c9190d80'
SELECT large_binary_data FROM ak_data WHERE id = 45
END OF STMT
PARSE #9:c=0,e=3249,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=649035954850
BINDS #9:
EXEC #9:c=0,e=245,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=649035956128
WAIT #9: nam='SQL*Net message to client' ela= 5 driver id=1952673792
#bytes=1 p3=0 obj#=49584 tim=649035956247
WAIT #9: nam='SQL*Net message from client' ela= 1189 driver
id=1952673792 #bytes=1 p3=0 obj#=49584 tim=649035957670
WAIT #9: nam='SQL*Net message to client' ela= 2 driver id=1952673792
#bytes=1 p3=0 obj#=49584 tim=649035957968
FETCH #9:c=0,e=166,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=1,tim=649035958028
... (many many many of those wait)
I'm sorry I provided a little informations on my first post, but I
though:
Yea this is a very common problem, just do that and that.
Again, I apologies for this bad start.
Regards
Kuon
Received on Sun Nov 13 2005 - 10:02:04 CST