Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Please Help

Re: Please Help

From: Peggy Marcantoni <peggyandkeith_at_worldnet.att.net>
Date: 1998/12/27
Message-ID: <764irt$l3@bgtnsc03.worldnet.att.net>#1/1

Steven,

I'm pretty new at this myself. Even though you can go through a tremendous amount if math as depicted in the Oracle 7.3 DBA handbook (and somewhat less in the 8.0 version from what I understand) that is not really necessary.

I've found the easiest way is to find out how many rows of data are stored per block after you've made your initial decisions on table storage parameters. Do this by loading a few hundred sample records into each table. Then use the function in the DBMS_ROWID package that will return the block number that a record is stored in when given the ROWID. (Sorry forget the function name :( )

IE:
Select DBMS_ROWID.function_that_returns_block(ROWID) as block, count(*) as records
from yourtablename;

The results should give you an idea of how many rows per block without bothering with the math. (I believe in Oracle 8 with extended ROWIDs you can also substring the left 16 characters of the ROWID).

Once you know how many rows per block, you can calculate the estimated table storage in blocks.

Hope I didn't add to the confusion.

steven wrote in message <36866C62.87D93F50_at_pacific.net.sg>...
>hi ,
>
> l'm currently troubling with two questions in my mind.
>
> first, How to calcculate the required table space for my complete
>scheme ?
>
> second, How to use new_time function to change GMT time to
>singapore time?
> (have tried several zone.., AST,EST... all not accurate).
>
>
> Thank you.
>
>with regards
>Internet Software Engineer
>
>
>
Received on Sun Dec 27 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US