Hi, 1) Before post things like this i recomend u check official doc first: http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcatdb.htm#BRADV318 2) We use zabbix(+zabora oracle scripts) monitors or use awr reports to investigate. Regards --- Samuel G. Cristobal <samuel.guinales@xxxxxxxxx> OCP10g,11g Senior Oracle Database System Engineer Fujitsu On 22 January 2014 19:27, Jeffrey Beckstrom <JBECKSTROM@xxxxxxxxx> wrote: > i) In rman connect to catalog only > > ii) Set dbid=<value>; > > iii) Unregister database; > > > > > Jeffrey Beckstrom > Database Administrator > Information Systems > Greater Cleveland Regional Transit Authority > 1240 W. 6th Street > Cleveland, Ohio 44113 > >>> nilesh kumar <nileshkum@xxxxxxxxx> 1/22/14 12:52 PM >>> > Hi All, > Hope every one is doing great!! > I have two questions. > 1. we have oracle rman catalog db in which all the prod databases are > registered, we cloned the database to a different server and by mistake > registered the database without changing the DBID to the same catalog. I > want to de-register the one which was recently added to the catalog as > DBname and DBID are same. > 2.How do we investigate in a step wise the performance problem when a > query is all of a sudden running slowly. I know there is no standard > solution for this problem, but would like to know how we should > systematically investigate the problem any notes would work for me. > > -- > Thanks & Regards > Nilesh > Oracle DBA (sqlplus "/as sysdba" is my world) > > "As our circle of knowledge expands, so does the circumference of darkness > surrounding it."--Einstein > "All men die, few men ever truly live" -- Braveheart > "You can get help from teachers, but you are going to have to learn a lot > by yourself, sitting alone in a room." --Dr. Seuss > "Know me for what I do and for not what I am. Judge me for what I can do > and not for what I have done."-Unknown > "Don't walk in front of me, I may not follow. Don't walk behind me, I may > not lead. Just walk beside me and be my friend."- Albert Camus > "Never argue with an idiot. They drag you down to their level and then > beat you with experience." - Unknown > > . > >