SQL Performance (MOSC)

MOSC Banner

performance over db link with sequences

edited Aug 31, 2018 5:05AM in SQL Performance (MOSC) 9 commentsAnswered ✓

Hello cracks,

The application architects need to execute a sequence.nexval in a read only dataguard database 11g, but the error is pretty clear when you try to execute a nextval:

select admin.testaitor.nextval from dual

ORA-16000: database open for read-only access

The solution that they propose, create another instance readwrite with the sequences and create a dblink to obtain the nextval.

Yes, we can do it... but

Anyone knows or have any experience with it?

Due to number of concurrent requests we can have problems with the performance over dblinks and nextval more than normal nextval operations?

thanks in advance

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center