Performance issue even after deletion

[ssubram]

I have a table which had 2,000,000 records and I've deleted 1,000,000 records from the table. But after the transaction is over the performance of the application is very slow and the values are not showing correctly in the application (I did not make any changes in the application). Will anyone help me what could be the problem.

[davey23uk]

you are kidding right?

You provide absolutly zero, nothing, no information and you want help.

What is the application?
What is it doing (selects, inserts)
Description of this table
indexes?
code?
explain plan?
up to date statistics

[vishal sood]

u have deleted data from the table and the performance is not good.

What I think is that even after the deleteing of data the High Water mark of the table is not shifted to below. When u scan the table it reads it up to High Water mark. This may be one reason for performance issue.

U can solve this by collesing or by exp/imp.

Vishal

[DaPi]

Originally posted by ssubram
. . . . and the values are not showing correctly in the application (I did not make any changes in the application).

I'm begining to suspect that there is an undocumented init parameter _GET_RIGHT_ANSWER which is false by default.

[marek_wiechula]

If your table does not include LONG fields and you have enough free space, then you can use ALTER TABLE .... MOVE TABLESPACE ... and specify the same tablespace and that will rebuild your table to reclaim the space freed up from the deletes and move your high water mark as well. If you have LONG fields then you may have to consider the export/import suggested by vishal sood.

[davey23uk]

dont try and second guess the answer, let him provide some info and then try and help