how will you see when the database was started using sql prompt?
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
What purpose does the model database server? : sql server DBA
what do you understand by flashback feature of oracle?
what is logical system in sap basis
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : 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
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How would you go about verifying the network name that the local_listener is currently using?
How can you control the amount of free space in your index pages? : sql server DBA
what functionality does oracle provide to secure sensitive information?
Can you redefine a table online?
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 to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
what are the differences of where and if in SAS?
What is dcl? : sql server DBA