Using V$_SEQUENCES
From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Fri, 6 Sep 2013 14:09:47 +0000
Message-ID: <AF02C941134B1A4AB5F61A726D08DCED0DE0E066_at_USA7109MB012.na.xerox.net>
Hi Folks,
We have a need to use V$_SEQUENCES.NEXTVALUE column in our custom programs to try and solve an issue that was introduced when we implemented RAC and is impacting our custom programs. Since this view is only available to the SYS schema, I am not sure what the implications are (performance, etc.) in exposing it to our custom schema. Are there any suggestions on whether it should be exposed to a non-SYS account? Thanks,
Amir
Date: Fri, 6 Sep 2013 14:09:47 +0000
Message-ID: <AF02C941134B1A4AB5F61A726D08DCED0DE0E066_at_USA7109MB012.na.xerox.net>
Hi Folks,
We have a need to use V$_SEQUENCES.NEXTVALUE column in our custom programs to try and solve an issue that was introduced when we implemented RAC and is impacting our custom programs. Since this view is only available to the SYS schema, I am not sure what the implications are (performance, etc.) in exposing it to our custom schema. Are there any suggestions on whether it should be exposed to a non-SYS account? Thanks,
Amir
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 06 2013 - 16:09:47 CEST