> Your web site is so usefull for Oracle Professional. Thank you for sharing
> your experties in Oracle.

My pleasure. Thanks for the positive feedback.

> I have questions that is bothering me:
> 1. Is there a way of finding-out when and by who a table or an object was
> deleted? If you do not have auditing on in Oracle. Since turing auditing on
> might affect the performance?

There is no way in Oracle to do this. As for performance, you can set an
audit just for tables that are deleted. This will not slow down
performance, as no other auditing is performed.

> 2. I have seen a lot of scripts to detect locks. But I am still looking for a
> script that can just tell me which locks are causing problems? I know there is
> utility in oracle to detect lock but in order to use that you have to run some
> scripts first. I am not sure how to use this utility.

The script is in $ORACLE_HOME/rdbms/admin, and it is called "utllockt.sql"
All you have to do is run it, and it will give you a "tree" structure of
which sessions are holding locks that are affecting other users.
> I would appriciate your help.
> Sarfraz
-Ari Kaplan
Independent Oracle DBA Consultant

<-> For 250+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->

Back to Ari Kaplan's Home Page Back to Ari Kaplan's Home Page