Start Up Information

In which file we can see start up information?

Questions by jaganmohanrao

Showing Answers 1 - 6 of 6 Answers

I will give you three options as im unsure of what your requirement is:-

If you're talking about a flatfile which contains the startup information, Well it is obviously the alert logfile. It can be found under the bdump (Background dump, The same directory which hold the trace files).

(or)

If you're talking about the initial startup parameters of your database, It can be found inside the control file (Location of your control file can be found inside the database's init.ora file).

(or)

If you just want to know when the database was started, Use this simple command in SQLPlus or an a query retreival tool of your choice.

select To_char(startup_time, 'Mon-dd-yyyy hh24:mi AM') as STARTUP_TIME from v$instance;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions