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
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
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
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
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
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
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
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: [
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
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
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
@nordstrom.com> cc:
Sent by: Subject: 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
|
| cc:
|
| Subject: 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
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
@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
p by b.value
/
"Pillai, Rajesh"
@nordstrom.com> cc:
Sent by: Subject: RE: Table Size
ml-errors
10/15/2003 04:19
PM
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
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
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
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
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
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
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
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
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
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 :
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
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 (
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
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
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
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
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).
35 matches
Mail list logo