Home » RDBMS Server » Server Administration » How can I query the redo log filenames?
How can I query the redo log filenames? [message #24714] Sat, 01 March 2003 10:53 Go to next message
Alex
Messages: 190
Registered: August 1999
Senior Member
How can I query the redo log filenames, their status and group number.

Report message to a moderator

Re: How can I query the redo log filenames? [message #24720 is a reply to message #24714] Sun, 02 March 2003 23:22 Go to previous message
Vikas Gupta
Messages: 115
Registered: February 2002
Senior Member
You can run the below sql:

select a.group#, member,thread#, sequence#, a.status from v$log a, v$logfile b where a.group# = b.group#

Regards,

Vikas.

Report message to a moderator

Previous Topic: How to use Unicode Vietnamese in Oracle 8.1.7
Next Topic: Help Me! Oracle8i installation error messages
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:31:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.