|
-
What exactly is the performance problem you're having? Are we talking about the entire database being slower or just queries against the tables you moved?
In the absence of this information try the following:
run explain plan for problem queries. Look for full table scans where index searches should be done.
run utlbstat/utlestat and analyze the results (report.txt)
John Doyle
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|