RE: Table Size

Raj,       Does the table already exist & have data or are you looking for a gestimate?   Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Pillai, Rajesh [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 3:24 PMTo: Multiple recipients of li

RE: Table Size

Try:   SELECT segment_type, segment_name,BLOCKS*8192/1024 "Kb"    FROM   DBA_SEGMENTS    WHERE  OWNER=UPPER('') AND SEGMENT_NAME = UPPER('');   Tony   -Original Message-From: Pillai, Rajesh [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 3:24 PMTo: Mu

Re: Table Size

On 10/15/2003 03:24:29 PM, "Pillai, Rajesh" wrote: Hi All, Could somebody help me in finding the actual size of an oracle table in GB. TIA, Rajesh Select sum(bytes)/1073741824 "Baud Rate" from dba_extents where segment_type='TABLE PARTITION' and segment_name=upper('&table'); -- Mladen Gogala

RE: Table Size

All the tables already exist and have data.   Thanks a lot for your response, Rajesh -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 12:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Table Size Raj

RE: Table Size

Title: Message If you are running stats on this table or can run stats use dba_segements   Allan -Original Message-From: Pillai, Rajesh [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 2:24 PMTo: Multiple recipients of list ORACLE-LSubject: Table Size Hi

Re: Table Size

Well, if the table is partitioned you'll get a nice fat zero On 10/15/2003 03:49:36 PM, Stephen Lee wrote: How about: select sum(bytes) from dba_segments where segment_name = 'TABLE_NAME'; -Original Message- Hi All, Could somebody help me in finding the actual size of an oracle

RE: Table Size

Steve, That gives you the size of the segments/extents that are the table, but not the actual amount of space being used. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, October 15, 2003 3:50 PM To: Multiple recipients of list ORACLE-L

RE: Table Size

How about: select sum(bytes) from dba_segments where segment_name = 'TABLE_NAME'; -Original Message- Hi All, Could somebody help me in finding the actual size of an oracle table in GB. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [

RE: Table Size

Title: Message Allan,   I cannot run stats on the table   Regards, Rajesh   -Original Message-From: Nelson, Allan [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Table Size If you are running stats

RE: Table Size

How true. My previous query would be incorrect also. ANALYZE the table COMPUTE STATISTICS (or ESTIMATE STATISTICS if it's a very large table) and then select num_rows * avg_row_len from dba_tables where owner = '&&table_owner' and table_name = '&&table_name' ; > -Original Message- > Goule

RE: Table Size

The query proposed by Anthony Hsu assumes that the tablespace has an 8K block size. Instead use the query below. Of course the result will be in bytes, not gigabytes, but any good DBA can instantly convert bytes to gigabytes or terabytes at a glance. :) P.S. I include LOB indexes in the table tota

RE: Table Size

@nordstrom.com> cc: Sent by: Subject: RE: Table Size

RE: Table Size

recipients of list ORACLE-LSubject: RE: Table Size All the tables already exist and have data.   Thanks a lot for your response, Rajesh -Original Message-From: Goulet, Dick [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 12:45 PMTo: Multiple recipients

RE: Table Size

| | cc: | | Subject: RE: Table Size | >--

Re: Table Size

no, it should get the correct size allocated to all the partitions select sum(bytes)/(1024*1024*1024) from dba_segments where segment_name = ; SUM(BYTES)/(1024*1024*1024) --- 18 select partition_name, sum(bytes)/(1024*1024*1024) from dba_segments

Re: Table Size

select bytes from dba_segments where segment_name = 'your_table';   divide the result by 1024*1024*1024 and you'll get the size in GB - Original Message - From: Pillai, Rajesh To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 15, 2003 9:24 PM Subje

RE: Table Size

@nordstrom.com> cc: Sent by: Subject: RE: Table Size ml-errors 10/15/2003 04:19 PM Please respond to ORACLE-L Allan, I cannot run

RE: Table Size

p by b.value / "Pillai, Rajesh" @nordstrom.com> cc: Sent by: Subject: RE: Table Size ml-errors 10/15/2003 04:19 PM

Re: Table Size

The best way to calculate the size of a table is to load it with 1000 production data rows. Then calculate the size of the predicted volume. You should be able to handle the first year of data at day 1. Do not loose time to calculate the table size at the byte level with formulas. For the temp

RE: Table Size

Prem - Simple way to get in the ballpark with table size. Figure out how large your average row is and multiply by the number of rows. This is only approximate and you'll want to size larger for indexes and other effects like the fact that your data blocks won't be 100% utilized. Better yet, create

Re: TABLE SIZE

Load up a sample set of rows, check the number of blocks used (analyze, then look at user_tables), then multiply by the expected increase factor hth connor --- Hamid Alavi <[EMAIL PROTECTED]> wrote: > Dear List, > > I have a question regarding Table size, I want to > put the small size of > tab

Re: TABLE SIZE

On Thursday 20 March 2003 18:19, Hamid Alavi wrote: > Dear List, Hi, > > I have a question regarding Table size, I want to put the small size of > tables in a small TBS,But don't know the size of table do I have to > calculate the size for which period, Assume we want to keep the data for 5 > yea

RE: Table Size?

Hamid Be sure to read "How to Stop Defragmenting and Start Living" very carefully so you really understand the concepts. These concepts free you from being overly concerned about details. Myself, I try to plan for 1 year of growth. The future gets too unpredictable past that. Dennis Williams

Re: table size.

Hi all I have a table with 8 millions rows and I deleted the 500 million. Then I exported tables (300 mb) and imported into another schema. After that, the table size is still the same. I thought table size should be taken much less space. the storage clause for both table is the same: pct10,pc

Re: table size.

Sorry : table is 8 million rows and I deleted 5 million rows. - Original Message - To: <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 12:20 PM > > Hi all > > I have a table with 8 millions rows and I deleted the 500 million. Then I > exported tables (300 mb) and imported into another

RE: table size.

500 mill? How did you do your export? Try compress=n -Original Message- Sent: Monday, July 08, 2002 1:23 PM To: Multiple recipients of list ORACLE-L Hi all I have a table with 8 millions rows and I deleted the 500 million. Then I exported tables (300 mb) and imported into another sc

Re: table size.

mitchell wrote: > > Hi all > > I have a table with 8 millions rows and I deleted the 500 million. Then I > exported tables (300 mb) and imported into another schema. After that, the > table size is still the same. > > I thought table size should be taken much less space. the storage clause for

Re: table size.

When using delete , the highwater mark does not change, so the table still use what was allocated. export/import also does noty resize the table. One way to do it, would be to precreate the table with a smaller size then import the data. --- mitchell <[EMAIL PROTECTED]> a écrit : > Sorry :

Re: table size.

Title: RE: table size. Hi Godlwski   Thanks for your reply.   This is not locally managed tablespace and num_rows are the same. The following result from dba_tables. This big different is empty_blocks.   I still confused why the size is the same but with much more empty_blocks.   I think

RE: table size.

This is expected behaviour. COMPRESS=Y doesn't make reference to the amount of space occupied by rows, just the amount of blocks allocated to the object as a whole. It's one of the great misunderstood parameters; really it should have been called COALESCE. Richard's suggestion will probably work (

RE: table size.

Dear Mitchell, If iam not mistaken the delete command does not free up the space..but it can be used in the future 4 the other records that r inserted... but incase of "Truncate" statement the tablesapce is freed of space u can try it out on a temporary table regards, Ams. -Origina

Re: TABLE SIZE?

This would be true if and only if you ignored block header space and ignored free space in blocks. What do you want to know The number of blocks under the high water mark? The total size of extents allocated to the table segment? The space allocated within those blocks? The total number of bl

Re: Table size

hi viraj, here's the method which'll let u know about the tables in a tablespace and thier occupied spaces. u can modify this according to your need by adding whatever more columns and condition u want. select segment_name,tablespace_name, sum(bytes)/1024 "KB" from dba_segments where segment_type

Re: Table size

select * from user_segments is a good start.. hth connor --- Viraj Luthra <[EMAIL PROTECTED]> wrote: > Hello all, > > How do I come to what tables are present in a > particular tablespace and then when I found the > table, can I come to know what amount of space it > consumes? > > eg. I want

Re: RE: table size.

Ji, Richard£¬ÄúºÃ£¡ hi, i think doing it with exp compress=N and It should use less space. If you are in oracle8i+, i think doing : alter table move tablespace new_ts storage(new storage clause) is faster, and then do: alter index index_on_the table rebuild (nologging if possible).