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 is the last version,the release date of that version and fix pack of ibm db2 udb?
How would you extract DDL of a table without using a GUI tool?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What are the different ways you can create databases in sql server? : sql server DBA
how can you connect from 10g user to 11g user??
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
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 does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is replication? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.