Interested to Buy Any Domain ? << Click Here >> for more details...
how will you see when the database was started using sql prompt?
- 2 Answers
- 6698 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
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what do you understand by fine-grained auditing?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is replication? : sql server DBA
how can you enable flashback feature?
Where would you look for errors from the database engine?
What are the recovery models for a database? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what are the differences of where and if in SAS?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
which background process invoke at the time of upgradation tell me???
How would you extract DDL of a table without using a GUI tool?
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.
