Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: couchman doubt

Re: couchman doubt

From: Jared Still <jkstill_at_cybcon.com>
Date: Tue, 06 May 2003 15:26:51 -0800
Message-ID: <F001.00591D3F.20030506152651@fatcity.com>

Do you have a 9i database available?

If not, you should create one.

run this query as sys:

  select max(ktuxescnw * power(2, 32) + ktuxescnb) from x$ktuxe

and then compare the results with what you find in each of the v$ views you mention below.

HTH Jared

On Monday 05 May 2003 09:06, bulbultyagi_at_now-india.net.in wrote:
> Hello list,
> I am preparing for the 031 exam for Oracle 9i
> I had a doubt in the following question asked by the couchman book :
>
> Q. You want to find out the current sequence number stored in your control
> file for backup purposes. Which two of the following views would you query?
>
> A*. V$DATABASE
>
> B . V$CONTROLFILE
>
> C . V$PARAMETER
>
> D*. V$CONTROLFILE_RECORD_SECTION
>
> My doubt : what sequence number is he asking for ? I can get the current
> log sequence number from v$controlfile_record_section by :
> select type , last_recid from v$controlfile_record_section where type =
> 'LOG HISTORY' ;
> There are other sequence numbers in v$database but why would I need the :
> CHECKPOINT_CHANGE# OR CONTROLFILE_SEQUENCE# for backup ( thats what the
> question asks ) . I cannot understand his answer of 'A' and 'D' both.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue May 06 2003 - 18:26:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US