-
Hi friends,
It may be a basic question, I need some clarification, I have table and I am inserting record. I want find out How much bytes It occupies, which current size of the table. Is it right
that if query from Dba_segment. column bytes for that segment name. Pl clarify
bye
Siva
-
-- create new temp table
-- execute 1 or couple of same insert statments
-- analize this table
-- see avg row length in all_tables (or dba_tables) view
-
thanks, as u suggested, I have done that, I have got the follwoing result Avg_row_length is 11, Whether is it bytes or Blocks, What is the unit of it. Thanks in advance
bye
siva
-
Originally posted by Siva
thanks, as u suggested, I have done that, I have got the follwoing result Avg_row_length is 11, Whether is it bytes or Blocks, What is the unit of it. Thanks in advance
bye
siva
It is number of bytes.
VVS Raju
8i DBA OCP
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|