(8.4.0)
status;
select * from information_schema.schemata;
select * from information_schema.innodb_tablespaces;
ls -l /var/lib/mysql
select * from performance_schema.global_variables;
select * from performance_schema.session_variables;
show plugins;
show engines;
select * from information_schema.events;
select * from mysql.user;
select * from information_schema.user_privileges;
select * from information_schema.schema_privileges;
(23c)
set markup csv on quote on
alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
set null '<<null>>'
select * from gv$version;
select * from gv$database;
select * from gv$instance;
select * from cdb_pdbs;
select * from cdb_tablespaces;
select * from cdb_data_files;
select * from cdb_temp_files;
select * from gv$log;
select * from gv$logfile;
select * from gv$asm_disk;
select * from gv$asm_diskgroup;
/opt/oracle/product/23c/dbhomeFree/OPatch/opatch lsinventory
/opt/oracle/product/23c/dbhomeFree/OPatch/opatch lsinventory -detail
alter database backup controlfile to trace;
cat /opt/oracle/diag/rdbms/free/FREE/trace/FREE_ora_3851.trc
select * from gv$parameter;
select * from gv$nls_parameters;
select * from cdb_properties;
select * from cdb_registry;
select * from gv$option;
select * from cdb_hist_wr_control;
select * from cdb_autotask_window_clients;
select * from cdb_scheduler_windows;
select * from cdb_profiles;
select * from cdb_directories;
select * from cdb_users;
select * from cdb_roles;
select * from cdb_sys_privs;
select * from cdb_role_privs;
select * from role_sys_privs;
select * from role_role_privs;
(16)
\pset pager 0
\pset null '<<null>>'
select version();
select * from pg_database;
select *,pg_tablespace_location(oid) from pg_tablespace;
select * from pg_shadow;
select * from pg_namespace;
select * from pg_settings;
\l+
\db+
\du+
\dn+
\dconfig
\des+
\dx
(2022)
select @@version;
select * from sys.databases;
select * from sys.filegroups;
select * from sys.database_files;
select * from sys.server_principals;
select * from sys.database_principals;
select * from sys.schemas;
select * from sys.server_permissions;
select * from sys.database_permissions;
select * from sys.configurations;
select * from sys.database_scoped_configurations;
dbcc useroptions
select * from msdb.dbo.sysjobs_view;
select * from msdb.dbo.sysjobs;
select * from msdb.dbo.sysschedules;
select * from msdb.dbo.sysjobschedules;
