I have one big table containing 10,00,000 records.
When i analyze this table the system hangs.
Is there any problem with SGA Size.
The same table if i analyze in other database with double SGA size it takes onle 3-4 minutes but it does not hang.
How i can speed up this tables's analyzing process.