Oracle数据库常用脚本（一）

select * from gv$version;

select dbid,name,to_char(created,'YYYY-MM-DD') created,log_mode from gv$database;

select version,instance_name,to_char(startup_time,'YYYY-MM-DD') startup_time,status from gv$instance;

select instance_name,status from gv$instance;

$ORACLE_HOME/OPatch/opatch lspatches$ORACLE_HOME/OPatch/opatch lsinventory

set line 200col value for a50set pagesize 100select * from nls_database_parameters;

show parameter spfile

cat $ORACLE_HOME/dbs/init实例名.ora

set line 300col tablespace_name for a20select tablespace_name,block_size,initial_extent,next_extent,max_size,status,contents,logging,extent_management,segment_space_managementfrom dba_tablespaces;

set pagesize 9999set linesize 132col tablespace_name for a35selecta.tablespace_name,a.Total_mb,f.Free_mb,round(a.total_MB-f.free_mb,2) Used_mb,round((f.free_MB/a.total_MB)*100) "%_Free"from(select tablespace_name, sum(bytes/(1024*1024)) total_MB from dba_data_files group by tablespace_name) a,(select tablespace_name, round(sum(bytes/(1024*1024))) free_MB from dba_free_space group by tablespace_name) fWHERE a.tablespace_name = f.tablespace_name(+)order by "%_Free"/