数据库属性统计语句

数据库属性统计语句 1. 2. 3. 4. 5. 6. 7. Ö??ú?ºhostname 8. select host_name,instance_name from v$instance; 9. Ö??ú?ºlsnrctl status 10. select name , value from v$parameter where name in ('local_listener','remote_listener'); 11. Ö??ú?ºAIX :.profile????HP-ux:.profile Linux:.bash_profile 12. select name , value from v$parameter where name in ('service_names'); 13. Ö??ú?ºwhoami 14. select username, default_tablespace,r.granted_role,s.privilege from dba_users u,dba_role_privs r ,dba_sys_privs s where username not in ('SYS', 'SYSTEM', 'OUTLN', 'MGMT_VIEW', 'MDSYS', 'ORDSYS', 'CTXSYS', 'ANONYMOUS', 'EXFSYS', 'DMSYS', 'DBSNMP', 'WMSYS', 'SYSMAN', 'XDB', 'ORDPLUGINS', 'SI_INFORMTN_SCHEMA', 'OLAPSYS', 'MDDATA', 'DIP', 'SCOTT', 'TSMSYS', 'IX', 'SH', 'BI', 'OE', 'HR', 'PM') and u.username=r.grantee and u.username=s.grantee 15. Ö??ú?ºecho $ORACLE_HOME 16. Ö??ú?ºcd $ORACLE_BASE/oraInventory 17. 18. select name,value from v$parameter where name in ('audit_file_dest','background_dump_dest','user_dump_dest','core_d ump_dest'); 19. select name,value from v$parameter where name in ('cluster_database','cluster_database_instances','cluster_intercon nects'); select instance_role,database_status from v$instance; 2021&. Ö??ú?ºifconfig ipconfig 22&23. select version from v$instance; 24&25. select * from V$nls_parameters where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET'); 26. select * from v$log; 27. select * from v$logfile; 28. archive log list; 29&30. select name,value from v$parameter where name in ('log_archive_max_processes') or name like 'log_archive_dest%'; 31. select name, value from v$parameter where name in ('background_dump_dest', 'core_dump_dest', 'user_dump_dest', 'audit_file_dest', 'max_dump_file_size', 'compatible', 'db_block_size', 'db_files', 'sga_target', 'large_pool_size', 'share_pool_size', 'log_buffer', 'sga_max_size', 'undo_management', 'undo_retention', 'log_archive_min_succeed_dest', 'log_archive_format', 'log_archive_start', 'open_cursors', 'parallel_max_servers', 'parallel_min_servers', 'processes', 'db_file_multiblock_read_count', 'db_writer_processes', 'hash_join_enabled', 'job_queue_processes', 'pga_aggregate_target', 'workarea_size_policy', 'timed_statistics', 'fast_start_mttr_target', 'hpux_sched_noage', 'timed_statistics', 'bitmap_merge_area_size', 'control_file_record_keep_time ', 'cursor_sharing', 'session_cached_cursors'); 32. 33. select * from v$tablespace; SELECT UPPER(F.TABLESPACE_NAME) "?í?Õ?äÃû", D.TOT_GROOTTE_MB "?í?Õ?ä?óÐ?(M)", D.TOT_GROOTTE_MB - F.TOTAL_BYTES "ÒÑÊ?ÓÃ?Õ?ä(M)", TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTTE_MB * 100, 2), '990.99') "Ê?ÓÃ?È", F.TOTAL_BYTES "?ÕÏÐ?Õ?ä(M)", F.MAX_BYTES "×î?ó?é(M)" FROM (SELECT TABLESPACE_NAME, ROUND(SUM(BYTES) / (1024 * 1024), 2) TOTAL_BYTES, ROUND(MAX(BYTES) / (1024 * 1024), 2) MAX_BYTES FROM SYS.DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) F, (SELECT DD.TABLESPACE_NAME, ROUND(SUM(DD.BYTES) / (1024 * 1024), 2) TOT_GROOTTE_MB FROM SYS.DBA_DATA_FILES DD GROUP BY DD.TABLESPACE_NAME) D WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME ORDER BY 1 DESC; ======================================================================================================================= 7. Ö??ú?ºhostname 9. Ö??ú?ºlsnrctl status 11. Ö??ú?ºAIX :.profile????HP-ux:.profile Linux:.bash_profile 13. Ö??ú?ºwhoami 15. Ö??ú?ºecho $ORACLE_HOME 16. Ö??ú?ºcd $ORACLE_BASE/oraInventory 20&21. Ö??ú?ºifconfig ipconfig 28. sqlplus : archive log list