audit pdb
sqlplus / as sysdba
set markup html on
spool pdb_info.html
show con_name;
show parameter service;
show parameter db_name;
SELECT dbms_utility.port_string AS "OS",
Count(cell_path) AS "cell_num",
CASE
WHEN Count(cell_path) > 0
AND dbms_utility.port_string LIKE 'x86_64/Linux%' THEN
'Is Exadata'
WHEN Count(cell_path) > 0
AND dbms_utility.port_string LIKE 'SVR4%' THEN
'Is Supercluster'
ELSE 'Is not Exadata'
END AS EXADATA
FROM v$cell;
select * from v$database;
select * from PDB_PLUG_IN_VIOLATIONS ;
select * from v$PDBS;
select * from v$instance;
select con_id, dbid, con_uid, guid, name, open_mode from v$containers;
select * from service$;
select * from cdb_service$;
select * from gv$active_services;
select * from dba_services;
spool off;
set markup html off;