Re: extent size for a log raw table

atiqul wrote:

> Hi All:
>
> I'm a novice and want to know how should I allocate storage for a
> table that has long raw data type. The table will be used for logging
> and will grow quickly. my db_block_size is 8k, the deafault is 128k
> next is 1024k pctincrease 0. How should I allocate storage???
>
> Thanks,
>
> -Atiqul

First question - are you forced to use 'long' or 'long raw'?

• If this is still under design, or can possibly be changed, switch to a LOB, either CLOB, or BLOB (to replace long raw).
• If this is based on Oracle8i or higher, find the developer and shake him/her severly until said developer promises to look at some documentation. (Specifically the "Application Developer's Guide - Fundementals" found at http://docs.oracle.com .)

Second question - what is the purpose of the long raw? Can you determine average size?

• Hopefully it's not some variant on "give me a long and I'll fill it dynamically at run time" or equivalent stupidity. If so, better to use a flat file, you are wasting the RDBMS's, CPU's, and administrator's time trying to fit that into a database efficiently.

Third - are you able to use Oracle8i or higher? If yes, why are you not using locally managed tablespaces? You might want to browse through the Database Administration Guide for the version you are using.

My answer to your question: use Oracle9i Release 2 or higher, use LOBs (or a proper design, if that's what's needed), use LMTs, use Enterprise Manager's Diagnostics Pack to track and predict disk usage.

/Hans Received on Fri Aug 13 2004 - 22:43:56 CDT