Answer Posted / bharath
explain plan for select * from t1 where num_col = '1';
select * from table(dbms_xplan.display);
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is dcl? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
how can a session indicate its interest in receiving alerts?
how can you initialize log miner?
What is the difference between clustered and non-clustered index? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What are the operating modes in which database mirroring runs? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how can you create a user-defined lock?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is the diffrence between core dba and apps dba?