Different results 'count (*) from V $ ASM_DISK'

1

I have a script that connects to an Oracle database and then selects:

select count(*) from V$ASM_DISK;

This script is in a .sql file, so I make the following call in the OS:

"$ORA_HOME/bin/sqlplus -L -S xxxx/xxxx @query.sql";

When executing the script as root , the result is 0, but when executing the same query as user oracle , the return is different.

Both users log in to Oracle.

I can not find the reason for this difference in return.

    
asked by anonymous 20.06.2018 / 17:36

0 answers