SQL Statements
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SQL Statements

  1. #1
    Join Date
    Jun 2001
    Posts
    30
    1. I would like to know how to find SQL statements that are not performing well. Is there any script for this.

    2. Is re-allocating indexes from one tablespace to another at the same time rebuilding them relieve space on the original tablespace.

    3. If I perform a full database export and import will it compress the database and give me some good performance?
    PMS

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    1. I don't think there is a script for that. Check out SQLabXpert (3rd party tool by Quest Software). You can use this tool to execute SQL stmts. and will recommend changes to the SQL.
    2. Yes.
    3. Not necessarily. If your segment(s) have a excessively large # extents, it is advisable. I had read an article in the Oracle magazine that even in such a case, the performance degradation is marginal/little. Poor SQL and non-selective indexes can also cause performance degradation.

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Originally posted by sunkutup
    1. I would like to know how to find SQL statements that are not performing well. Is there any script for this.
    You can check it through the V$SQLAREA view.


    Have your user tables and indices analyzed. Set your optimizer mode to choose. Use bind variables in the query.....


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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