hpuxrac wrote:
> On Jul 13, 6:43 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> StefanKapitza wrote:
>>> On Jul 13, 11:54 pm, DA Morgan <damor..._at_psoug.org> wrote:
>>>> Can anyone get this to work in any version of 10gR1 or 10gR2?
>>>> col instart_fmt noprint;
>>>> col inst_name format a12 heading 'Instance';
>>>> col db_name format a12 heading 'DB Name';
>>>> col snap_id format 99999990 heading 'Snap Id';
>>>> col snapdat format a18 heading 'Snap Started' just c;
>>>> col lvl format 99 heading 'Snap|Level';
>>>> set heading on;
>>>> break on inst_name on db_name on host on instart_fmt skip 1;
>>>> ttitle off;
>>>> SELECT TO_CHAR(s.startup_time,' DD MON "at" HH24:MI:SS') INSTART_FMT,
>>>> di.instance_name INST_NAME, di.db_name DB_NAME, s.snap_id SNAP_ID,
>>>> TO_CHAR(s.end_interval_time,'DD MON YYYY HH24:MI') SNAPDAT,
>>>> s.snap_level LVL
>>>> FROM dba_hist_snapshot s, dba_hist_database_instance di
>>>> WHERE di.dbid = s.dbid
>>>> AND di.instance_number = s.instance_number
>>>> AND di.startup_time = s.startup_time
>>>> ORDER BY snap_id;
>>>> SELECT dbms_undo_adv.undo_advisor(<starting_snap_id, <ending_snap_id>,
>>>> 1) FROM dual;
>>>> For example:
>>>> SELECT dbms_undo_adv.undo_advisor(587, 600, 1)
>>>> FROM dual;
>>>> If you do not have a license to access the two dba_hist tables
>>>> please do not do so at your employer's expense.
>>>> I would like to know the exact version number of 4 decimal places
>>>> and whether it succeeds or fails. Thanks.
>>>> --
>>>> Daniel A. Morgan
>>>> University of Washington
>>>> damor..._at_x.washington.edu (replace x with u to respond)
>>>> Puget Sound Oracle Users Groupwww.psoug.org
>>> Failing with Ora-14552
>>> Windows x84 10.2.0.3.0
>>> Centos x64 10.2.0.2.0
>>> Centos x86 10.2.0.3.0
>>> regards
>>> s.kapitza
>> I had a feeling thanks. Does anyone have a version where it works?
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
>
> Probably will be fixed in the next release maybe. Fails on hpux pa
> risc 10.2.0.3
>
> If you have a reproducible test case then submit an sr if you have
> access to a support contract.
Thanks. I have an SR open and was looking to see if it was just my
environment, which is a bit different than most, or if it was the
general case which it appears to be.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jul 13 2007 - 23:56:37 CDT
