Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2013
    Posts
    1

    Question Unanswered: How to estimate the size of the database object, before creating it?

    A typical question arise in mind.

    As DBA's, we all known to determine the objects size from the database.

    But before creating an object(s) in database or in a schema, we'll do an analysis on object(s) size in relation with data growth. i.e. the size we are estimating for the object(s) we are about to create.

    for example,
    Create table Test1 (Id Number, Name Varchar2(25), Gender Char(2), DOB Date, Salary Number(7));

    A table is created.
    Now what is the maximum size of a record for this table. i.e. maximum row length for one record. And How we are estimating this.

    Please help me on this...

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Although this article was written a while ago (for Oracle 8) the principles are still the same:
    Space Estimations for Schema Objects
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jul 2013
    Posts
    5
    For checking the size of the table, you need to query,
    sql> select bytes/1024/1024 from dba_segments where segment_type='TABLE' and segment_name='TABLE_NAME';




    Quote Originally Posted by 201287 View Post
    A typical question arise in mind.

    As DBA's, we all known to determine the objects size from the database.

    But before creating an object(s) in database or in a schema, we'll do an analysis on object(s) size in relation with data growth. i.e. the size we are estimating for the object(s) we are about to create.

    for example,
    Create table Test1 (Id Number, Name Varchar2(25), Gender Char(2), DOB Date, Salary Number(7));

    A table is created.
    Now what is the maximum size of a record for this table. i.e. maximum row length for one record. And How we are estimating this.

    Please help me on this...

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    For checking the size of the table, you need to query,
    sql> select bytes/1024/1024 from dba_segments where segment_type='TABLE' and segment_name='TABLE_NAME';
    That's not the question that was asked:

    How to estimate the size of the database object, before creating it?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  5. #5
    Join Date
    Jul 2013
    Posts
    5
    sir,frankly speaking, iam couldn't able to understand your question, the size of database object should be planned accordingly based on with in available mount point., database size should be with in the mount point., i think for particular row size calculation possible using rowid,

  6. #6
    Join Date
    Aug 2013
    Posts
    2

    Is that clear your answer

    Plan the database tables and indexes and estimate the amount of space they will require.
    Oracle provides solutions of indexes and tables for spaceing.

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Oracle provides solutions of indexes and tables for spaceing.
    please post URL to where above is documented.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •