OraFAQ Forum: Server Administration » Table size not visible

Home » RDBMS Server » Server Administration » Table size not visible (oracle 9207, sun solaris 5.9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table size not visible [message #317541]

Thu, 01 May 2008 18:45

harry07
Messages: 61
Registered: June 2007
Location: now york

Member

Hi Forum

On Oracle 9207 on solaris, I want to determine the size of a table. The table is present in dba_objects , but I dont see any value in bytes column of dba_segments table. The table has 566 rows of data.

Any idea !!

Report message to a moderator

Re: Table size not visible [message #317542 is a reply to message #317541]

Thu, 01 May 2008 18:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Forgive me, but you are doing something WRONG!


SQL> select count(*) from user_segments where segment_type = 'TABLE' and bytes is null;

  COUNT(*)
----------
         0

use sqlplus along with CUT & PASTE the whole session which supports your initial problem report.

Report message to a moderator

Re: Table size not visible [message #317545 is a reply to message #317542]

Thu, 01 May 2008 19:01

harry07
Messages: 61
Registered: June 2007
Location: now york

Member

It returns 0. Anyhow it will just list the tables with null in bytes column. I need to determine the size.

I also tried checking number of blocks in table and multiplying by db_block_size, but there is null also in blocks field of dba_tables.

Report message to a moderator

Re: Table size not visible [message #317549 is a reply to message #317541]

Thu, 01 May 2008 19:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You're On Your Own (YOYO) since you can't/won't follow requests
& you keep changing your story
>but there is null also in blocks field of dba_tables.
>I dont see any value in bytes column of dba_segments table

[Updated on: Thu, 01 May 2008 20:12] by Moderator

Report message to a moderator

Re: Table size not visible [message #317553 is a reply to message #317549]

Thu, 01 May 2008 22:16

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Is it an externally organised table (EOT)?

Report message to a moderator

Re: Table size not visible [message #317575 is a reply to message #317545]

Fri, 02 May 2008 01:06

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

there is null also in blocks field of dba_tables.

This is normal in multiple cases: no gathered statistics, partition table, iot...

Post your query on DBA_SEGMENTS, actual size is in DBA_SEGMENTS as size is a physical property, dba_objects and dba_tables show you logical or structural properties.

Edit: As Ana said, you can't have null bytes in dba_segments. Null bytes would mean there is a null/non-existent/ghost segment.

Regards
Michel

[Updated on: Fri, 02 May 2008 01:11]

Report message to a moderator

Previous Topic:	How to decide for a SGA size
Next Topic:	Importing datafiles from oracle 8 into oracle 10

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 18:00:01 CDT 2024