DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: DB size??

  1. #1
    Join Date
    Jan 2001
    Posts
    1
    Hi!
    Need help badly!!

    I am new to this DBA stuff!!
    Wehave a Oracle 8 Database and we need to start testing, so have been asked to create a test database.
    How do I create teh DB and how do I knowhow much space I need on the server. Is there a way to identify the production Database size? How wouldI know teh amt.of diskspace?

    PlueeeZZ help!!!
    Grateful to you.

  2. #2
    Join Date
    Jan 2001
    Posts
    3
    Hi

    this query will give the size of the database

    select sum(BYTES)/(1024*1024)||' mb' 'database size' from dba_data_files;

    if u want to c the free space available u have to do it at OS level

    bye
    ravi
    Ravi Prasad

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    There is a program called dbassist that is a GUI that can help you create your database. How big the database is depends on the size of the data.
    Jeff Hunter

  4. #4
    Join Date
    Dec 2000
    Posts
    21
    Where can I get dbassist?
    Thanks!

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    Its GUI based oracle utility

    Just like exp/imp/sql*plus to create/modify/delete a database. Usually it will be in $O_H/bin. Otherwise you can search for it in NT/ Use find command in Unix.

    You need to have x-windows in unix to invoke this utility.

  6. #6
    Join Date
    May 2000
    Posts
    50
    Usually when installing the Oracle client for administrator dbassist also installs as part of it.

Posting Permissions

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


Click Here to Expand Forum to Full Width