ITPub博客

===============================change root password=====================================================恢复root密码 （1）按e编辑grub菜单 （2）选择linux16那行，追加 init=/bin/sh   (中间有个空格)（3）ctrl+X引导 （4）# mount  -o  remount,rw  /（6）# echo "12345...

ASM Header BACKUP[root@#] more /oracle/ASM/asm_dg_meta_backup.sh. ~oracle/.bash_profileexport ORACLE_SID=+ASM1export ORACLE_BASE=/u02/oracleexport ORACLE_HOME=/u02/11204/gridexport GRID_HOME=$ORACLE_HOMEASMHEADER_BACKUP_HOME=/oracle/ASMBACKUP_FILE=$ASMHEADER_BACKUP_HOME/ASM_DG_META_BACKU...

before we start to PSU upgrade,we should backup database(cold or hot backup) and the oracle home directory. C:\Users\Admin>chcp 437    #change language mode to english.D:\>set ORACLE_HOME=E:\oracle\product\10.2.0\db_1D:\>echo %ORACLE_HOME%E:\oracle\product\10.2.0\db_1E:\oracle...

Oracle 10.2.0.5 opatch utility upgrade.E:\oracle\product\10.2.0\db_1\OPatch>set ORACLE_HOME=E:\oracle\product\10.2.0\db_1E:\oracle\product\10.2.0\db_1\OPatch>echo %ORACLE_HOME%E:\oracle\product\10.2.0\db_1E:\oracle\product\10.2.0\db_1\OPatch>opatch versionInvoking OPatch 10.2.0.4.9OPatch Ve...

从oracle官网上下载相关patchset:https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=qdu85yeys_9&_afrLoop=602692658891347p8202632_10205_WINNT.zip 注意这个是windows 32bit的1.安装过程的话和正常的安装一样，根据提示一步一步往下操作.(图形界面)安装过程中遇到的问题提示ORASLAX10.D...

Oracle收集统计信息的采样比例: SELECT owner, segment_name, ROUND (SUM (bytes) / 1024 / 1024) size_mb,         case when sum(bytes)/1024/1024 = 1  ...

Top sql: select rownum as rank, a.*from (select PARSING_SCHEMA_NAME RUN_USER, --执行用户SQL_FULLTEXT, --SQL文本,全，带格式sql_text, --SQL文本前面部分elapsed_Time , --单位是微秒，语句执行完的总时间，包括CPU时间和等待时间cpu_time , --CPU时间，语句运行的时间elapsed_Time - cpu_time wait_time,tru...

ASM Disks Performance metric:SELECT a.name          disk_group_name,       b.path          disk_path,       b.reads     &n...

select name,sector_size,block_size,allocation_unit_size,state,type,total_mb,free_mb,(total_mb-free_mb) "used_mb",round((total_mb-free_mb)/total_mb,4)*100 "Used Ratio" from v$asm_diskgroup;

col spid format a10col inst_id format a7col owner format a15col object_name format a20col machine format a30col program format a20select pr.spid,se.inst_id,se.sid,se.serial#,ob.owner,ob.object_name,se.osuser,se.machine,se.terminal,se.program,gvl1.ctime,(select count(*)-1 from gv$lock  w...

select s.SID,s.SERIAL#,t.USED_UBLK,t.USED_UREC from v$transaction t,v$session s where t.ADDR=s.TADDR order by sid

select tablespace_name,sum(decode(status,'EXPIRED',bytes,0)) "EXPIRED", round(sum(decode(status,'EXPIRED',bytes,0))/sum(bytes),4)*100 "Reused Ratio",       sum(decode(status,'UNEXPIRED',bytes,0)) "UNEXPIRED", sum(decode(status,'ACTIVE',bytes,0)) "ACTIVE",  &nbsp...

select inst_id,to_char(first_time,'yyyy/mm/dd') "Date",sum(decode(to_char(first_time,'HH24'),'00',1,0)) H00,sum(decode(to_char(first_time,'HH24'),'01',1,0)) H01,sum(decode(to_char(first_time,'HH24'),'02',1,0)) H02,sum(decode(to_char(first_time,'HH24'),'03',1,0)) H03,sum(decode(to_char(first_time,'...

SELECT TO_CHAR(SYSDATE, 'yyyy/mm/dd hh24:mi:ss') TIME,       SUM(reloads) reloads, round(sum(reloads)/sum(pins),4)*100 "Library Cache Reload Ratio",        SUM(gets) gets, SUM(gethits) gethits, round(sum(gethits)/sum(gets),4)*100 "GetHit ...

select to_char(sysdate,'yyyy/mm/dd hh24:mi:ss') currenttime,round(1-(physical_read-physical_reads_direct)/(db_block_gets+consistent_gets-physical_reads_direct),4)*100 "Buffer Cache Hit Ratio",       buffer_busy_waits,free_buffer_waitsfrom (SELECT TO_CHAR(SYSDATE, 'yyy...

SELECT s.sid, s.serial# serial, s.module, s.program, s.status session_status, t.status txn_status, t.start_time start_time,       r.name rbs, t.used_urec undo_records, t.used_ublk, t.log_io txn_logical_io,  t.phy_io txn_physical_io, t.cr_get txn_consistent_gets,&...

SELECT s.sid sid, s.serial# serial, s.module module, s.program program, s.event, SUM(su.blocks) temp_blocks,       trunc(SUM(su.blocks) * 8096 / 1024 / 1024) temp_size  , sql.sql_text   FROM v$sort_usage su, v$session s ,v$sql sql WHERE su.session_addr...

select  PID , SID , LADDR , NAME , GETS from GV$LATCHHOLDER where inst_id = USERENV('Instance')

select l.latch# latch,l.name, nvl(c.latches, 0) children, l.gets, l.misses, l.gets-l.misses "Simple Gets",       round((l.gets-l.misses) / l.gets,4)*100 "Simple Gets Ratio(%)",       l.spin_gets, round(l.spin_gets / l.gets,4)*100 "Spin Ge...

SELECT (SELECT parsing_schema_name FROM v$sqlarea WHERE sql_id = a.max_sql_id) SCHEMA,       (SELECT MODULE FROM v$sqlarea WHERE sql_id = a.max_sql_id) MODULE,        a.literal_sql_cnt,        a.ex...