Re: What is the size of arc files

From: Steve Howard <stephen.howard_at_us.pwcglobal.com>
Date: 4 Oct 2004 07:09:10 -0700
Message-ID: <6d8b7216.0410040609.58041d14@posting.google.com>

umeshoracle_at_yahoo.com (U C) wrote in message news:<fd94e273.0410032325.9a5d7bd_at_posting.google.com>...
> Hi All,
> I would like to know few things from about different log files:
>
> 1) What is the size of arc file. When it creates new files and what is
> the maximum size that it can have.

select name,blocks*block_size from v$archived_log;

>
> 2) What is the size of trc files. When it creates new files and what
> is the maximum size that it can have.
>
> 3) What is the size of core folder and how many files can be in each
> core folder and of what size.
>
> 4) If i am having nearly 250000 transaction a day then what will be
> size of my arch, core and trc.
>

That is impossible to answer. Unless you are regularly tracing user sessions, however, you shouldn't see very much space used by these directories.

The arch question is also impossible to answer. You can run your transactions through a test system, and run the query above to get how much has been generated for any given period. TOAD and other tools also have a GUI for showing you this kind of stuff.

> suggestion will be of great help to me.
>
> Regards
> Umesh
Received on Mon Oct 04 2004 - 09:09:10 CDT