QUESTION POSED ON: 12 March 2007
We have successfully delivered one database application to one customer, on Oracle 10gR2 server (v10.2.0.2, Unix, 64-bit).
Since this is a RAC environment and because of some problems within one
stored procedure we have implemented ("ORA-01801: date format too long for
internal buffer"), which happens from time to time only in the last
couple of weeks, we have asked to get access rights for two admin
views, V$INSTANCE and GV$INSTANCE.
My idea was that this problem can be caused by one Oracle instance
(host machine) which is not properly configured and/or has a malfunction.
After checking the view GV$INSTANCE, there is only one row returned with
inst_id = 1.
What does that actually mean? Is this then really a RAC environment or only a single Oracle instance?
Or it is possible to limit the result of this view, in order to prevent
the user to check/examine the system configuration?
Thanks in advance.
|
