Select on SM$TS_Free very slow after patch
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Select on SM$TS_Free very slow after patch

  1. #1
    Join Date
    May 2000
    Location
    Huntsville, AL. USA
    Posts
    52
    Selecting from certain DD views extremely slow after 8.1.7.2.1 patch application. Selecting storage option from tree in DBA studio accesses same views and runs about 60 seconds before displaying tablespace space information.

    I recently patched two servers to 8.1.7.2.1, up from 8.1.7.0.0. Before I had no difficulty selecting from any of the views owned by SYS, but after the patch install I have found one of the queries I typically use to calculate the amount of freespace in a TS 'hangs' for about 60 seconds before returning a result. The problematic view seems to be SM$TS_Free. Any query to this view takes about a minute, and I'm not certain what about the patch if anything would have affected this. I am concerned that other problems may exist that I have not yet encountered. I reran the catalog.sql and catsvrmg.sql scripts in hopes this would correct the issue, but it did not. Both databases were patched without any errors being displayed. One has the behavior, the other does not.

    The other unusual behavior I have noticed since the patch is that this database can have no users connected, I can issue a shutdown immediate, and it takes 8-9 minutes waiting for active calls to complete. If no long running jobs are occurring, and the v$session view shows only me and the background processes I do not understand why it would take such a long time to shutdown the database. I can shutdown immediate, startup normal, and at the instant the db is open shutdown immediate again and it still takes forever. Are there issues with 8.1.7.2.1 causing these problems?

    Thanks,
    Ray

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Interesting... In this case I would apply at once 8.1.7.3 and see waht happens next.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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