-
Does anyone know how i can simply display some messages in SQLPlus? I'm not sure what the syntax is to put up a certain message after running a particular script.
I believe that DOS has this function by simply putting an ECHO command when you want the promt to appear, it is a similar sort of function that i am looking for in SQLPlus.
Thx
-
Hi Hummy,
You can use the PROMPT command for example the following script
PROMPT LATCH: LOW LEVEL MECHANISMS USED TO PROTECT SHARED DATA STRUCTURES
PROMPT
PROMPT GETS: SUCESSFULL WILLING TO WAIT REQUESTS
PROMPT MISSES: UNSUCESSFULL WILLING-TO-WAIT REQUEST
PROMPT IMMEDIATE_GETS: SUCESSFULL IMMEDIATE REQUEST
PROMPT IMMEDIATE_MISSES: UNSUCESSFULL IMMEDIATE REQUEST
select
c.name,
a.gets,
a.misses,
a.immediate_gets,
a.immediate_misses
from v$latch a, v$latchname c
where a.latch# = c.latch#
and a.name = 'redo copy';
will give the following output:-
SQL> @latches
LATCH: LOW LEVEL MECHANISMS USED TO PROTECT SHARED DATA STRUCTURES
GETS: SUCESSFULL WILLING TO WAIT REQUESTS
MISSES: UNSUCESSFULL WILLING-TO-WAIT REQUEST
IMMEDIATE_GETS: SUCESSFULL IMMEDIATE REQUEST
IMMEDIATE_MISSES: UNSUCESSFULL IMMEDIATE REQUEST
NAME GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES
-------------------- ---------- ------- -------------- ----------------
redo copy 196 0 5636 1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|