how will you see when the database was started using sql prompt?
- 2 Answers
- 5369 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / mohapatra.gouranga@gmail.com
In RAC env.
select instance_name,status,host_name,to_char
(startup_time,'DD-MON-YY HH24:MI:SS')
from gv$instance order by instance_name;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how can you create a user-defined lock?
what is the use of recording information about current session?
How can you control the amount of free space in your index pages? : sql server DBA
what is the use of ocr?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What is the default fill factor value? : sql server DBA
Why would you call update statistics? : sql server DBA
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
how can you communicate with operating system files from oracle?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is the importance of a recovery model? : sql server DBA
how does an oracle clusterware manage crs resources?
what are the types of connection load-balancing?
how can you implement fine-grained auditing?
