how will you see when the database was started using sql prompt?
- 2 Answers
- 5890 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 does an alert gets signaled?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
internal architecture
What purpose does the model database server? : sql server DBA
which background process invoke at the time of upgradation tell me???
Explain materialized views and how they are used.
what do you understand by flashback feature of oracle?
what is logical system in sap basis
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is a crs resource?
What is dcl? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
