performance over db link with sequences
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