A Wetpaint Site

Sign in to Wetpaint

Sign in or

Determine Oracle Instance Status

Page Versions
To-Dos

Key: additions deletions

Showing 7 pages

	Date/Time	Made By	Edit Note	Type	Scope
	Feb 13 2008, 11:25 AM EST	olapdba		edit	9 words added 7 words deleted
Change: gv$instance; --Or use V$THREADselect INSTANCE,instance, STATUS, ENABLED,status, OPEN_TIME,enabled, CHECKPOINT_TIMEopen_time, checkpoint_timefrom v$thread;INSTANCE STATUS . ENABLED. OPEN_TIME ......... CHECKPOINT_TIME-------- -------- -------- ------------------- -------------------sigd1 .. OPEN ....PUBLIC . 14/01/2008 15:26:51 23/01/2008 15:16:05sigd2 .. OPEN ....PUBLIC . 15/01/2008 16:23:03 23/01/2008 15:16:06 View changes from previous version. (Word count: 134)
	Feb 7 2008, 9:50 AM EST	olapdba		edit	9 words added 4 words deleted
Change: col instance_name for a8 hea 'INSTANCE'col host_name for a15 hea 'HOSTNAME' col version for a10 select instance_name, version, host_name, status, database_status,to_char(startup_time,'DD-MON-YYYY HH:MI:SS') strtd from v$instance;INSTANCE_NAME ..INSTANCE VERSION .. HOSTNAME ...... STATUS ..... DATABASE_STATUS . STARTED ------------------------ ---------- --------------- ------------ ----------------- --------------------orcl .............. View changes from previous version. (Word count: 134)
	Feb 7 2008, 9:47 AM EST	olapdba		edit	9 words added
Change: database_status,to_char(startup_time,'DD-MON-YYYY HH:MI:SS') strtd from gv$instance; --Or use V$THREAD select INSTANCE, STATUS, ENABLED, OPEN_TIME, CHECKPOINT_TIME from v$thread; INSTANCE STATUS . ENABLED . OPEN_TIME ......... CHECKPOINT_TIME-------- -------- -------- ------------------- -------------------sigd1 .. OPEN ....PUBLIC . 14/01/2008 15:26:51 23/01/2008 15:16:05sigd2 .. OPEN ....PUBLIC . 15/01/2008 16:23:03 23/01/2008 15:16:06 View changes from previous version. (Word count: 128)
	Jan 23 2008, 4:04 PM EST	yusukeyurameshi	Add observetion about RAC Database	edit	51 words added
Change: RAC Databaseselect instance_name, version, host_name, status, database_status,to_char(startup_time,'DD-MON-YYYY HH:MI:SS') strtd from gv$instance; --Or use V$THREAD select INSTANCE, STATUS, ENABLED, OPEN_TIME, CHECKPOINT_TIME from v$thread;INSTANCE STATUS ENABLED OPEN_TIME CHECKPOINT_TIME-------- -------- -------- ------------------- -------------------sigd1 OPEN PUBLIC 14/01/2008 15:26:51 23/01/2008 15:16:05sigd2 OPEN PUBLIC 15/01/2008 16:23:03 23/01/2008 15:16:06 View changes from previous version. (Word count: 128)
	Jan 22 2008, 1:50 PM EST	olapdba		edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 56)
	Jan 22 2008, 1:49 PM EST	olapdba		edit	55 words added
Change: 'STARTED' col host_name for a15 hea 'HOSTNAME' col version for a10 select instance_name, version, host_name, status, database_status,to_char(startup_time,'DD-MON-YYYY HH:MI:SS') strtd from v$instance; INSTANCE_NAME .. VERSION .. HOSTNAME ...... STATUS ..... DATABASE_STATUS . STARTED ---------------- ---------- --------------- ------------ ----------------- --------------------orcl ........... 11.1.0.6.0 OLAPDBA-LAP ... OPEN ....... ACTIVE .......... 10-NOV-2007 09:47:42 View changes from previous version. (Word count: 56)
	Jan 22 2008, 1:45 PM EST	olapdba		create	No content added or deleted.
Change: Created by olapdba Jan 22 2008, 1:45 PM EST for: no reason given

JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then try again.

Home