RE: Row Lock Waits on SYSTEM.ICOL$
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 3 Feb 2009 09:19:37 -0500
Your post shows one wait, why is one wait a concern? More importantly
what was the application doing? Was it doing DDL?
Production tasks generally should not perform DDL operations and if you
got a row wait on sys.icol$ then DDL was being performed.
-- Mark D Powell --
Phone (313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA
Sent: Tuesday, February 03, 2009 3:39 AM
To: ORACLE-L
Subject: Row Lock Waits on SYSTEM.ICOL$
Folks
During an OLTP Benchmark Run of a CRM Banking Application
following Row Lock Waits are experienced on SYSTEM.ICOL$
Oracle 10.2.0.4.0
HP-UX B.11.11
Any pointers please? ... Will Share AWR as needed.
Cheers & Thanks V much
Segments by Row Lock Waits
Owner
Tablespace Name
Object Name
Subobject Name
Obj. Type
Row Lock Waits
% of Capture
SYS
SYSTEM
ICOL$
TABLE
1
100.00
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely
for the use of the addressee(s). If you are not the intended recipient,
please
notify the sender by e-mail and delete the original message. Further,
you are not
to copy, disclose, or distribute this e-mail or its contents to any
other person and
any such actions are unlawful. This e-mail may contain viruses. Infosys
has taken
every reasonable precaution to minimize this risk, but is not liable for
any damage
you may sustain as a result of any virus in this e-mail. You should
carry out your
own virus checks before opening the e-mail or attachment. Infosys
reserves the
right to monitor and review the content of all messages sent to or from
this e-mail
address. Messages sent to or from this e-mail address may be stored on
the
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
Other related posts:
