RE: couchman doubt

Bulbultyagi

   My experience is that sometimes Couchman is a little more difficult than the actual examination. But I'm okay with that. The exam questions are taken from the Oracle Education class notes, so whenever possible I refer to them. As I recall you are working on the Architecture & Administration module.
>From page 7-11, Obtaining Information about Archiving, "Query the dynamic
performance view V$DATABASE."

   If you are to this point, you are ready to take the exam. You won't make 100% anyway because you are always told to "select the best answer". This means many questions have more than one true answer, but you must decide which one is more true. But you'll pass, and once you pass, that is all that will matter.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, May 09, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L

Yes I have 9.0.1.1.1 enterprise edition availible on win32 I tested the given query out and the checkpoint_change# column value from v$database matches the result of the query you gave You mean to say that couchman is asking me where to find the checkpoint number ?

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.

• Original Message ----- To: <ORACLE-L_at_fatcity.com>; <bulbultyagi_at_now-india.net.in> Sent: Wednesday, May 07, 2003 03:58

>
> 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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <bulbultyagi_at_now-india.net.in
  INET: bulbultyagi_at_now-india.net.in

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).