Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

What is the difference when I use the listener (@), to run a query ??

edited Mar 20, 2015 10:02AM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 1 commentAnswered

Hi


What is the difference when I use the listener ), to run a query ??,

The case is the following:

I need to make a select to view ASM, I make next connection and I have rows:


sqlplus USER / passwd DataBase

But, if I use the next string; I don't have rows.

sqlplus USER / passwd

the conections is the same user.

The script is....:

SELECT 'DATA' dum1,
       free_mb / DECODE (TYPE, 'NORMAL', 2, 'HIGH', 3, 'EXTER N', 1)
          SPACE_AVAIL,
       (total_mb - free_mb) SPACE_USED
  FROM v $ asm_diskgroup_stat
WHERE name = 'DG_OTHER_SCHEMA'
       AND (state = 'MOUNTED' OR state = 'CONNECTED');

Somebody know about this

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center