ttitle left  "The Path to the Wallet" skip 2 


column WRL_TYPE      format a10 heading "WRL|Type"
column WRL_PARAMETER format a20 heading "Wallet|Params"
column STATUS        format a10 heading "Status"
column WALLET_TYPE  format a10 heading "Wallet|type"
column WALLET_ORDER  format a9 heading "Status"
column FULLY_BACKED_UP  format a9 heading "Backup"
column CON_ID  format 999 heading "Con|ID"
column inst_id format 999 heading "Inst|ID"


select 	inst_id
        , WRL_TYPE
		,WRL_PARAMETER
		,STATUS
		,WALLET_TYPE
		,WALLET_ORDER
		,FULLY_BACKED_UP
		,CON_ID
from gv$encryption_wallet
/



column name format a40
column masterkeyid_base64 format a60

ttitle left  "Get the Master Key for Tablespaces" skip 2 

select  name
       ,utl_raw.cast_to_varchar2( utl_encode.base64_encode('01'||substr(mkeyid,1,4))) || utl_raw.cast_to_varchar2( utl_encode.base64_encode(substr(mkeyid,5,length(mkeyid)))) masterkeyid_base64  
  FROM (select t.name, RAWTOHEX(x.mkid) mkeyid 
          from v$tablespace t
		     , x$kcbtek x 
		 where t.ts#=x.ts#)
/		 


ttitle left  "Get the Master Key for the Controlfile" skip 2 

select  utl_raw.cast_to_varchar2( utl_encode.base64_encode('01'||substr(mkeyid,1,4))) || utl_raw.cast_to_varchar2( utl_encode.base64_encode(substr(mkeyid,5,length(mkeyid)))) masterkeyid_base64  
  FROM (select RAWTOHEX(mkid) mkeyid 
          from x$kcbdbk)
/		  


ttitle left  "Get the Master Key for Tables" skip 2 

select mkeyid from enc$;


ttitle left  "Witch Columns are encrypted?" skip 2 

column owner          format a15  heading "Owner"
column table_name     format a15  heading "Table|Name"
column column_name    format a15 heading "Column|Name"
column ENCRYPTION_ALG format a35 heading "Encryption|Algo"

select owner          
	,table_name     
	,column_name    
	,ENCRYPTION_ALG 
from dba_encrypted_columns
/

ttitle off