|
Home > Archive > Oracle Databases > December 2005 > Displaying database info
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Displaying database info
|
|
| deanfamily 2005-12-14, 3:25 am |
| I have a manually created 9i database, and I need to return some information
on it. I need to show the database name, user datafiles, temporary
datafiles, control files, and logfile groups. Anyone know how to do this?
| |
| Vince Laurent 2005-12-14, 11:24 am |
| Download and setup this cool tool
http://dbamon.com/orastat/
On Wed, 14 Dec 2005 02:38:20 GMT, "deanfamily"
<deanfamily@verizon.net> wrote:
>I have a manually created 9i database, and I need to return some information
>on it. I need to show the database name, user datafiles, temporary
>datafiles, control files, and logfile groups. Anyone know how to do this?
>
-----------------------------------------------------
Come race with us!
http://www.mgpmrc.org
| |
| scenario 2005-12-16, 9:24 am |
| Hi,
The easy way is to make select on v$ view : v$instance, v$database,
v$datafile, ...
Look at the orcale doc on v$ view, dba_ view,you'll get allthe informations
you need.
"Vince Laurent" < vincelaurent@REMOVET
HISsbcglobal.net> a écrit dans le
message news: uik0q1hu1lm08jh7j920
ufq5e6m5uima1p@4ax.com...
> Download and setup this cool tool
>
> http://dbamon.com/orastat/
>
> On Wed, 14 Dec 2005 02:38:20 GMT, "deanfamily"
> <deanfamily@verizon.net> wrote:
>
information[color=da
rkred]
this?[color=darkred]
>
> -----------------------------------------------------
> Come race with us!
> http://www.mgpmrc.org
|
|
|
|
|