RAW volume verification

select 'dbv file='


name

' blocksize='

block_size

' end='

(bytes/block_size)

' logfile='

substr(name, instr(name, '/', -1, 1) +1)

'.'

file#

'.log' from v$datafile /

HOw to find out list of Hidden parameters in oracle.


SET LINESIZE 145


SET PAGESIZE 9999

SET VERIFY off

COLUMN ksppinm FORMAT A42 HEAD 'Parameter Name'

COLUMN ksppstvl FORMAT A39 HEAD 'Value'

COLUMN ksppdesc FORMAT A60 HEAD 'Description' TRUNC

SELECT

ksppinm

, ksppstvl

, ksppdesc

FROM

x$ksppi x

, x$ksppcv y

WHERE

x.indx = y.indx

AND TRANSLATE(ksppinm,'_','#') like '#%'

/

How to find out how many parallel slaves available in database. 



 select STATUS , count(*) from v$PX_PROCESS group by status ;

STATUS      COUNT(*)
--------- ----------
IN USE            87
AVAILABLE          1

SQL>