SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sys_guid() performance improvement

3703006Oct 25 2018 — edited Oct 25 2018

Hi,

I did a test about 120,000 data. When I insert with no generation sys_guid(), running time: 4.55s . While if I add sys_guid(), running time: 20.3s. It's too slow.

Is there any possibility to do some improvements? I need to generate a primary key for each insert row.

Best regards,

Added on Oct 25 2018

11 comments

1,487 views