Home » RDBMS Server » Server Administration » Table size not visible (oracle 9207, sun solaris 5.9)
icon1.gif  Table size not visible [message #317541] Thu, 01 May 2008 18:45 Go to next message
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 !!
Re: Table size not visible [message #317542 is a reply to message #317541] Thu, 01 May 2008 18:50 Go to previous messageGo to next message
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.
Re: Table size not visible [message #317545 is a reply to message #317542] Thu, 01 May 2008 19:01 Go to previous messageGo to next message
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.
Re: Table size not visible [message #317549 is a reply to message #317541] Thu, 01 May 2008 19:57 Go to previous messageGo to next message
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 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Is it an externally organised table (EOT)?
Re: Table size not visible [message #317575 is a reply to message #317545] Fri, 02 May 2008 01:06 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  


Current Time: Fri Dec 06 01:46:53 CST 2024