Home » RDBMS Server » Server Administration » Archive Logs - Question
Archive Logs - Question [message #143245] Wed, 19 October 2005 10:49 Go to next message
humair77
Messages: 13
Registered: August 2005
Junior Member
Can anyone guide me on how to check the size size for archive file system and amount of log it generates every day?

Any help/suggestions will be highly appreciate

Thanks
Re: Archive Logs - Question [message #143602 is a reply to message #143245] Fri, 21 October 2005 03:19 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
This script might help: http://www.orafaq.com/scripts/sql/archdist.txt

Best regards.

Frank
Re: Archive Logs - Question [message #143672 is a reply to message #143602] Fri, 21 October 2005 07:14 Go to previous message
humair77
Messages: 13
Registered: August 2005
Junior Member
Tahnk You very much sending my this script.

Could you give me any hints on changing this script to find archive logs generated on daily basis.

I would appreciate your help.

Thanks
Humair
Previous Topic: Corrupted Datafile Block
Next Topic: Use of NOLOGGING ...!!!
Goto Forum:
  


Current Time: Fri Jan 10 12:49:15 CST 2025