SQL help

List Database sessions & their status

Select * from ( Select username,status from V$session where username is not null)  pivot  ( count(status)   for status in ('ACTIVE','INACTIVE','KILLED')) ;

RMAN Queries

V$RMAN_OUTPUT -- details about recent rman jobs

Users with Default passwords

select * from dba_users_with_defpwd; 

Encryption:

select * from v$encrypted_tablespaces ;

select * from dba_encrypted_columns; 

Character Set:
select * from nls_database_parameters;

Check Features:
select name,last_usage_date from dba_feature_usage_statistics where detected_usages>0  order  by 1;