Hi Saj,
I just tried at least 4 on 8.1.7
v$instance
v$sga
v$sgastat
v$parameter
There are probably more, don't know where the two number is coming from.
John
[EMAIL PROTECTED] wrote:
Hi
Anyone now which 2 V$ views can be accessed while in nomount mode ?
Also what is a tempfile ?
TIA
Title: RE: nomount
Is this some sort of OCP test for us listers??
-Original Message-
From: Sajid Iqbal [mailto:[EMAIL PROTECTED]]
Sent: 11 December 2001 12:20
To: Multiple recipients of list ORACLE-L
Subject: nomount
Hi
Anyone now which 2 V$ views can be accessed while
lol looks like it eh?
I know that you can view v$instance while the database is not mounted - not
sure about the other one..
And - straight from the Oracle Concepts Manual (page 126)
Locally managed temporary tablespaces have temporary datafiles (tempfiles),
which
are similar to ordinary
v$parameter
v$sga
v$option
v$process
v$session
v$version
v$instance
nomount stage, right from my Oracle Admin book published by Oracle.
David Ehresmann
Oracle DBA 8 8i OCP
MCI Worldcom
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sajid Iqbal
Hi,
Views that can be read in the nomount stage are:
v$parameter, v$sga, v$option, v$process, v$session, v$version and
v$instance.
And tempfile is latest method of defining Oracle database temporary files
for Temp tablespaces.
Mujeeb Chowdhry
[EMAIL PROTECTED] 12/11/01 07:20AM
HiAnyone
No, these are questions I have been asked but couldn't readily find the
information on... so I thought someone out there must know :-)
Regards
Saj
On Tue, 11 Dec 2001, Mark Leith wrote:
lol looks like it eh?
I know that you can view v$instance while the database is not mounted - not
And you believed it ?
-Original Message-
Sent: Tuesday, December 11, 2001 9:10 AM
To: Multiple recipients of list ORACLE-L
v$parameter
v$sga
v$option
v$process
v$session
v$version
v$instance
nomount stage, right from my Oracle Admin book published by Oracle.
David Ehresmann
Oracle