Performance Issue (Insert taking long time)
Hi..
I have two tables say table A and B. Table A is back up of B. Table A and B having the identical structure with same indexes created (3 indexes). In table A, I have data some were around 500 million rows (or more than that). I can not delete or truncate table A. And from one of Stroed procedure, I'm inserting more data (say > 1 million more rows) from table B to A. But this insertion is taking long and long time. Some times apprears to be hanged. But from v$seesion I can identify the Query execution. I have tried PARALLEL Query, but seems not working. I tried to user HINTs also, but invain. Rollback segments are 4GB each and there are 3 RBS.
Can anyone suggest me what can be the issues......??? Any help will be appreciated..
Bhavesh