Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    bangalore
    Posts
    14

    Unanswered: Is there a performance impact when the data file is used about 80 percent

    Hi,

    Having some serious performance problems while doing DML operations on our database which was working fine earlier ( when we had less data) . If we look at the data file, it is almost used by 80 percent. would like to know whether this has an impact on database performance?

    Murali
    Murali Mohan Rao. M

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    62
    If the datafile is 80% full, you MUST add another data file to this tablespace.
    Add a data file and then check the performance.
    Regards,

    Rushi

  3. #3
    Join Date
    Jan 2004
    Posts
    99
    Originally posted by Rushi
    If the datafile is 80% full, you MUST add another data file to this tablespace.
    Add a data file and then check the performance.
    yes adding a datafile may not necesserily solve your performance problems, If your adding datafiles that obviously means your table/s are becoming bigger....therefore you may need to analyze your tables and or rebuild your indexes.

Posting Permissions

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