Re: problem with archivelogs
From: (wrong string) übl, PG <ibz.hotline_at_bmw.de>
Date: Mon, 26 Aug 2002 08:24:38 +0200
Message-ID: <3D69C9A6.1A3CC5CE_at_bmw.de>
T CHAN FIRST TIM
4 rows selected.
Date: Mon, 26 Aug 2002 08:24:38 +0200
Message-ID: <3D69C9A6.1A3CC5CE_at_bmw.de>
Daniel Roy wrote:
>
> Also,
> how big are your log files anyway? (select bytes from v$log should te
ll you).
>
> Daniel
Sorry I forgott in my last posting
SVRMGR> select * from v$log
2> ; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUSFIRS
T CHAN FIRST TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ---- ------ --------- 1 1 665 1048576 2 YES INACTIVE 160067 24-AUG-02 2 1 666 1048576 2 YES INACTIVE 160078 24-AUG-02 3 1 667 1048576 2 YES INACTIVE 160600 26-AUG-02 4 1 668 1048576 2 NO CURRENT160611 26-AUG-02
4 rows selected.
bye
Peter
P.S. This time the logs are smaller I think
-- , \ / , / \ )\ /( / \ / \ ( \ / ) / \ / \ \_at_ @/ / \ | |\../| | | \VV/ | | BMW IBZ Hotline | | Heidemannstr. 170 | | 80807 M nchen | | Tel. +049 89 382 47588 | | | | /\ / \\ \ /\ | | / V )) V \ | |/ ` // ' \| ` V PGP encryption key 40264B4DReceived on Mon Aug 26 2002 - 08:24:38 CEST