This content has been marked as final. Show 2 replies
100 Mb is really tiny!!!
You also most likely won't be able to get a 90 percent reduction.
The easiest solution is to set the compress attribute of the directory you are saving the files in. This is transparent to Oracle, and you will get savings.
You can also zip the file using your favorite zip utility. You won't get 90 percent reduction.
You would be better off
- buying extra disk
- get rid of 126.96.36.199 as soon as possible. Support for Oracle 9i will stop end of July.
Senior Oracle DBA
My database is in archive log mode and archive size is 100 MB. I want to reduce it to 10MB.In fact the size of your archived logs is generally fixed by the size of your online redo logs. So if you reduce
how can I get this? please guide me in detail
the size of your online redo logs you'll get smaller archived logs.
But, the consequence will be that your database will have more redolog switchs (they will be filled ten times
faster as you reduce their size from 100 Mo to 10 Mo) and, it's not good for the performances.
More over, you'll get ten times more Archived logs (ten times smaller), so the space used by the Archived logs
won't change (it depends on the database activity).
So, as previously posted, it may be better to compress the Archived logs so that they finally use less space.
If you decide to compress them, you should check that the database is not writing (archiving) on it, the view
V$ARCHIVED_LOG may help you to get the list of the redo logs already archived.
Hope this help.
Edited by: Lubiez Jean-Valentin on Mar 6, 2010 11:22 AM