Re: RedoLog utilization investigation

From: GenTLe <alexthegentleSPAMMATI_at_hotmail.com>
Date: Wed, 27 Apr 2005 11:05:22 +0200
Message-ID: <d4nkkj$du9$1@newsreader.mailgate.org>

Ero seduto nel Korova Milk Bar, arrovellandomi il gulliver per sapere cosa fare della serata, quando Mark D Powell mi ha disturbato scrivendo:

Sorry, but I'm totally newbie with Oracle...

Ok, the only tablespace which has redolog active is UNDOTBS1, all the others tablespc are with NO redolog.
I would know if these redologs (3 files of 100MB) has been used in the past for another tablespace: one of these:

Mabeuro0 (user Mabeuro)
Bhieuro0 (user Bhieuro)
Gmbeuro0 (user Gmbeuro)

> select log_mode from v$database;

NOARCHIVELOG
> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

---------- ---------- ---------- ---------- ---------- --- ----------------

FIRST_CHANGE# FIRST_TIM
------------- ---------

1 1 3833 104857600 1 NO INACTIVE 359103578 27-APR-05 2 1 3834 104857600 1 NO CURRENT 359105803 27-APR-05 3 1 3832 104857600 1 NO INACTIVE 359101540 27-APR-05
> The last few rows of
> select * from v$log_history order by first_time

RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#
---------- ---------- ---------- ---------- ------------- --------- ------------

3828 556712048 1 3828 359093162 27-APR-05 359095189

3829 556712183 1 3829 359095189 27-APR-05 359097315

3830 556712285 1 3830 359097315 27-APR-05 359099126

3831 556712425 1 3831 359099126 27-APR-05 359101540

3832 556712564 1 3832 359101540 27-APR-05 359103578

3833 556712683 1 3833 359103578 27-APR-05 359105803

226 rows selected.

> select * from v$archived_log order by first_time

no rows selected

> Then someone would have more to go on and could make a better
> response.

Thankyou very much :-)

-- 
GenTLe ...di Varese, provincia.
TL1000S + Mito 125 per la pista
La mia HP: http://digilander.iol.it/thegentle/index.htm

Esistono bionde intelligenti? Si', le birre.

Received on Wed Apr 27 2005 - 04:05:22 CDT