OraFAQ Forum: Server Administration » Oracle start date/time

Home » RDBMS Server » Server Administration » Oracle start date/time

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle start date/time [message #176790]

Fri, 09 June 2006 10:57

ozzy80
Messages: 55
Registered: June 2005

Member

Hello,

I am new to this... can anyone let me know how and where to look for to know when the datase was started recently?

Thanks,

Ozzy

Report message to a moderator

Re: Oracle start date/time [message #176794 is a reply to message #176790]

Fri, 09 June 2006 11:26

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Look into alert_sid.log or v$instance.startup_time

oracle@mutation#desc mutation v\$instance

Table:v$instance
 Name                                Null?    Type
 ----------------------------------- -------- ------------------------
 INSTANCE_NUMBER                              NUMBER
 INSTANCE_NAME                                VARCHAR2(16)
 HOST_NAME                                    VARCHAR2(64)
 VERSION                                      VARCHAR2(17)
 STARTUP_TIME                                 DATE
 STATUS                                       VARCHAR2(12)
 PARALLEL                                     VARCHAR2(3)
 THREAD#                                      NUMBER
 ARCHIVER                                     VARCHAR2(7)
 LOG_SWITCH_WAIT                              VARCHAR2(11)
 LOGINS                                       VARCHAR2(10)
 SHUTDOWN_PENDING                             VARCHAR2(3)
 DATABASE_STATUS                              VARCHAR2(17)
 INSTANCE_ROLE                                VARCHAR2(18)
 ACTIVE_STATE                                 VARCHAR2(9)

Report message to a moderator

Re: Oracle start date/time [message #176801 is a reply to message #176794]

Fri, 09 June 2006 13:11

ozzy80
Messages: 55
Registered: June 2005

Member

thanks!

Report message to a moderator

Previous Topic:	overhead with varchar2?
Next Topic:	Manual 9i DB installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 15:28:44 CST 2025