Results 1 to 3 of 3

Thread: Database sizing

  1. #1
    Join Date
    Sep 2003
    Location
    Greater London
    Posts
    17

    Unanswered: Database sizing

    Hello,

    What is the correct way to size a database? At present I have sized it using the dbf's for the physical size. How do incorporate the logical size?

    Regards,

    Gill

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    set pagesize 1000
    select s.TABLESPACE_NAME,
    d.BYTES/1048576,
    sum(s.bytes)/1048576 Free,
    round((sum(s.bytes)*100)/d.bytes,2)||'%' Percentage
    from v$datafile d,
    dba_free_space s
    where d.file#=s.file_id
    group by s.TABLESPACE_NAME,d.BYTES;

    Hope it helps,
    Breen.

  3. #3
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198

    Re: Database sizing

    Originally posted by gellis
    Hello,

    What is the correct way to size a database? At present I have sized it using the dbf's for the physical size. How do incorporate the logical size?

    Regards,

    Gill
    IMHO, The best method for tuning is checking fragmentation. And in some cases determinig if partitioned tables and indexes will give you speed advantage.

    I have attached a script that will determine extents for you. And what you do is make sure to date stamp the report. Check for tables that have extents. Get them cleaned up. Export-Drop-Import or other method. TOAD is good for creating create table scripts. If that table comes back to haunt you again then seriously look at partitioning.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

Posting Permissions

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