Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: Unique Oracle data base problem

    Dear oracle users
    i have a unique problem in oracle

    i am using 0racle 9ias .....my data base is expanding un expectedly
    i mean the its consuming the hard disc space un expectedly.. besides that we dont have much data entered into the data base.....

    what could be the problem to this....

    i also have a problem with the data base shutting down unexpectedly
    hear what i do i just to restart the server...help help

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    not enough information.
    you say you have a db problem, but you don't list the version or the OS.

    you say you have a space problem but you don't list disk space used,
    tablespace sizes or anything.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Apr 2004
    Posts
    3
    Originally posted by The_Duck
    not enough information.
    you say you have a db problem, but you don't list the version or the OS.

    you say you have a space problem but you don't list disk space used,
    tablespace sizes or anything.


    my o/s windows server 2000 service pack 4

    anyway i have a disc problem i really cant figure out the table size
    only what i know is the system is consumng more space than expected

  4. #4
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    your problem isn't very clear from your desription

    run this query as system or sys (or someone with access to the views) and post the results

    SELECT d.NAME, t.NAME, d.status, d.bytes
    FROM v$datafile d, v$tablespace t
    WHERE t.ts# = d.ts#
    ORDER BY t.NAME

    What version of the database, you say you are running 9ias does that mean you are also using a 9i database?

    find the alert log for the database and post what it says when the database crashed, it will be something like c:\oracle\admin\orcl\bdump\orclALRT.LOG
    There are 10 types of people in the world, those that know Binary and those that don't.

  5. #5
    Join Date
    Apr 2004
    Posts
    3
    Originally posted by robert xr4x4
    your problem isn't very clear from your desription

    run this query as system or sys (or someone with access to the views) and post the results

    SELECT d.NAME, t.NAME, d.status, d.bytes
    FROM v$datafile d, v$tablespace t
    WHERE t.ts# = d.ts#
    ORDER BY t.NAME

    What version of the database, you say you are running 9ias does that mean you are also using a 9i database?

    find the alert log for the database and post what it says when the database crashed, it will be something like c:\oracle\admin\orcl\bdump\orclALRT.LOG

    today 21 april 2004 it crashed 2 times
    alert log

    attache

Posting Permissions

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