Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2005
    Posts
    276

    Unanswered: Recycle the database

    The schema that I work on is running very slow. When I asked my DBA he said that they are recycling the database. What does that mean?

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    Recycle = shutdown + startup
    JoeB
    save disk space, use smaller fonts

  3. #3
    Join Date
    Jul 2005
    Posts
    276
    What can be the reason for a normal running database to go slow. Recycling shouldn't take too long then, right? But the database is still running slow.

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    You may need also to request from the DBA's that they ANALYZE your schema, maybe using the DBMS_STATS utility to collect optimizer statistics as an aid to improving performance.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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