I'm trying to use debug option in toad 9.7 but it shows this message "UNABLE TO FIND RAC CONNECTION INFORMATION FOR RAC (INST_ID=1)"
I found some information and it says that Oracle doesn't support debugging accros RAC instances. We have a RAC instances and It was working fine until now but all of a sudden i faced the error message today.
Even I followed some instructions to create additional entries in tnsname.ora for each RAC nodes without load balancing parameter but it fails and faced the same error message.
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines