| Deleting records and system performance [message #49868] |
Thu, 14 February 2002 14:02  |
Srinivas Bhogineni
Messages: 2
Registered: February 2002
|
Junior Member |
|
|
We are currently running Oracle 8.1.6.0.0 (HP-UX 11.0 Operating System). In order to improve system performance, we recently deleted a large amount of old data from one of our tables and executed the analyze table command (analyze table xxx compute statistics). However, system performance did not seem to improve immediately. After the server was rebooted, however, we saw a dramatic improvement in performance.
If a large amount of data is deleted from a table, when do the changes take affect? According to our DBA it should be immediate - but this does not seem to be the case. Does Oracle need to be recycled? Is there a compact command that we can run?
Any help will be greatly appreciated. Thanks.
|
|
|
|
|
|
|
|
| Re: Deleting records and system performance [message #49889 is a reply to message #49868] |
Fri, 15 February 2002 07:21  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
|
Your DBA is correct. Deleting the data and doing a commit is immediate. If your table was large and doing full table scans or the amount of data retrieved into the redo logs, SGA, and rollback segments was large rebooting would clear it all out. Now you are using a smaller data set and you can see the diff.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
