John Dunn wrote:
Is there a database query that will tell me what Unix account oracle is installed under? I know that in most cases this will be oracle, but is there a database query that will tell me?
This is more a SQL*Plus+shell command rather than a query, but if you're worried about the case of installed account not matching running account, you could always:
SQL> ! ls -l $ORACLE_HOME/bin/oracle | awk '{print $3}' oracleI'll leave relevant changes as an exercise for the reader if your operating system promises you "genuine advantage" :-)
Ciao Fuzzy :-) -- //www.freelists.org/webpage/oracle-l