[askdba] Re: [dba_gurus] How to get entire production database information
- From: Nisar Tareen <ntareen@xxxxxxxxx>
- To: don karnash <donkarnash@xxxxxxxxx>, dba_gurus@xxxxxxxxxxxxxxx
- Date: Sun, 23 Jan 2005 19:28:48 -0800 (PST)
Try , Select * from V$database;
Nisar Tareen
don karnash <donkarnash@xxxxxxxxx> wrote:
Hi I was wondering if there is a way to get all the information about a
database like version, whether it is in archive mode or not, if the control
files are multiplexed, where are the redo log files stored, tablespace &
datafiles info etc.
---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
[Non-text portions of this message have been removed]
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/dba_gurus/
To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
Other related posts:
