asked on

Oracle 10g - Insert into statment

Hi,

Im running this statment in a Oracle 10g database...

insert /*+ PARALLEL(10) */ into dp_securitycounter select DPSEQUENCE.nextval, c.dpsc_id, sa.dpsa_id,s.dpcnt_sendvalue,s.dpcnt_receivevalue,s.dpcnt_lastackvalue,sysdate,sysdate from bell_mig_counter s , dp_card c, dp_simapplication sa,dp_cardprofile cp where s.iccid = c.dpsc_iccid and c.dpcp_id=cp.dpcp_id and s.tar_name=sa.dpsa_tar and c.dpcp_id=sa.dpcp_id;

Its taking a very long time and I would like to know if there is a way to check the progress...

After two hours running it the target table (the one that will have the records inserted), I did a count on the table and there were no rows there:

select count (*) from dp_securitycounter;

=====

So, how can I check the progress of the command and IF its writing somehting...

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Anthony Perkins

Please request that the MS SQL Server topic be removed, as it does not apply.

Thanks.

johnsone

I would look in V$TRANSACTION. You should see the number of undo blocks being used keep increasing. You can see that in the USED_UBLK column and you can join to V$SESSION by using V$TRANSACTION.SES_ADDR = V$SESSION.SADDR

Since you are running parallel, you may have to query all the slave processes to get the correct count.

joaotelles

ASKER

How can I check this?
Check for extent allocation and/or size of the table

SOLUTION