- 博客(102)
- 资源 (13)
- 收藏
- 关注
转载 Scripts:查询db_block_buffer使用率的脚本perf_db_block_buffer_usage.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 09:04:24 601
转载 Scripts:查询参数信息的脚本parms.sql
-------------------------------------------------------------------------------------------- File name: parms.sql-- Purpose: Display parameters and values.--- Author: Kerry Osborn
2014-05-30 09:04:11 530
转载 Scripts:查询所有参数修改信息的脚本parm_mods.sql
-- parm_mods.sql---- Shows all parameters (including hidden) that have been modified. -- Uses the lag function so that a single record is returned for each change.-- It uses AWR data - so only
2014-05-30 09:04:00 609
转载 Scripts:查询数据文件IO使用率的脚本 perf_file_io.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 09:03:48 666
转载 Scripts:查询每个数据文件等待时间的脚本perf_file_waits.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 09:03:11 741
转载 Scripts:查询每个session命中率的脚本perf_hit_ratio_by_session.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 09:02:17 658
转载 Scripts:查询每个数据文件使用效率的脚本perf_file_io_efficiency.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 09:01:54 524
转载 Scripts:报告log file switch切换的频率perf_log_switch_history_count_daily_all.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 09:01:41 799
转载 Scripts:报告每次log file switch切换的redo大小perf_log_switch_history_bytes_daily_all.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 09:01:28 599
转载 Scripts:perf_redo_log_contention.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 09:01:14 462
转载 Scripts:显示数据库所有锁的脚本locks_blocking.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 08:56:11 611
转载 Scripts:显示数据库中锁和等待锁的脚本 locks_blocking2.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 08:55:56 554
转载 Scripts:显示数据库中DML锁的脚本 locks_dml_lock_time.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 08:55:44 579
转载 Scripts:显示数据库中DML,DDL锁的脚本locks_dml_ddl.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 08:55:34 638
转载 Scripts:显示数据库中每小时每日的redo切换的脚本logswitchsize.sql
@@headerset term off/*** Author : Vishal Gupta* Purpose : Display houly and daily redolog switches by size* Parameters : None** Revision History:* ===================
2014-05-30 08:55:23 712
转载 Scripts:显示数据库每小时每日redo切换频率的脚本logswitchfreq.sql
@@headerset term off/*** Author : Vishal Gupta* Purpose : Display houly and daily redolog switches by frequency* Parameters : None** Revision History:* ==============
2014-05-30 08:55:12 1000
转载 Scripts:显示数据库中长时间运行的SQL的脚本longtime.sql
set linesize 333 set pagesize 1000
2014-05-30 08:55:03 658
转载 Scripts:显示数据库中长时间运行的操作的脚本longops.sql
set linesize 320 col MESSAGE format a80
2014-05-30 08:54:57 708
转载 Scripts:查询等待事件的SQL脚本owi_event_names.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-30 08:54:50 589
转载 Scripts:根据sid,ospid来查询进程信息的脚本os_pid.sql
set lines 132SELECT s.username, s.user#, s.sid, s.serial#, s.prev_hash_value, p.spid os_pid FROM V$SESSION S, v$process p WHERE sid = nvl('&sid',sid)and p.spid = nvl('&os_pid',p.spid)and p.a
2014-05-30 08:54:40 1967
转载 Scripts:常用查询数据库中锁的脚本
select p.spid, a.serial#, c.object_name, b.session_id, b.oracle_username, b.os_user_name from v$process p, v$session a, v$l
2014-05-29 10:58:40 536
转载 Scripts:显示有LOB列的表的脚本(慎用)LobData.sql
REM List table and column information for LOBs for a specific userREM REM UNDO handling with LOBs is not designed for frequent updatesREM Frequent updates are best handled with PCTVERSIO
2014-05-29 10:58:28 766
转载 Scripts:dump blob列内容的脚本(慎用)lob_dump_blob.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-29 10:58:14 750
转载 Scripts:dump clob列内容的脚本(慎用)lob_dump_clob.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-29 10:57:58 633
转载 Scripts:dump nclob列的脚本(慎用)lob_dump_nclob.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-29 10:57:45 665
转载 Scripts:此脚本慎用lob_fragmentation_user.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-29 10:57:27 539
转载 Scripts:查询log file sync 等待的脚本lfsdiag.sql
-- NAME: LFSDIAG.SQL-- -------------------------------------------------------------------------- AUTHOR: Michael Polaski - Oracle Support Services-- --------------------------------------------
2014-05-29 10:57:12 1125
转载 Scripts:查询使用UNDO最多的10个SQL hundo10.sql
set linesize 333 col USERNAME format a15
2014-05-29 10:56:58 1262
转载 Scrtips:查看隐含参数的脚本hidden_param.sql
set linesize 120col name for a30col value for a10col PDESC for a50SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.KSPPDESC PDESCFROM SYS.x$ksppi x, SYS.x$ksppcv yWHERE x.indx = y.indxAND x.ks
2014-05-29 10:56:25 562
转载 Scripts:查询library cache lock和hang的脚本library_cache_locks_pins.sql
REM --------------------------------------------------------------------------------------------------REM Author: Riyaj Shamsudeen @OraInternals, LLCREM www.orainternals.comREM REM Fun
2014-05-29 10:56:12 703
转载 Scripts:显示数据库中闪回区的相关信息 fra_status.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-29 10:55:49 571
转载 Scripts:显示数据库中闪回区文件的信息fra_files.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-29 10:55:38 534
转载 Scripts:显示闪回区告警的信息fra_alerts.sql
-- +----------------------------------------------------------------------------+-- | Jeffrey M. Hunter |-- | jhunter@
2014-05-29 10:55:25 631
转载 Scripts:根据sql_id创建sql_profile的脚本(此脚本要慎用)gps.sql
-------------------------------------------------------------------------------------------- File name: gps.sql---- Purpose: Creates a SQL Profile on a statement adding the GATHER_PLAN_
2014-05-29 10:55:13 595
转载 Scripts:查看使用PGA最多的10个SQL的脚本hpga10.sql
set line 230 alter session set nls_date_format='yyyy-mm-dd hh
2014-05-29 10:54:53 991
转载 Scripts:查看耗用buffer cache最多的10个SQL的脚本hbuf10.sql
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; select sysdate from dual;
2014-05-29 10:54:47 588
转载 Scripts:查询使用临时表空间最多的10个SQL htemp10.sql
set linesize 200 set pagesize 999
2014-05-29 10:54:36 1966
转载 Scripts:查询排序最多的10个SQL hsort10.sql
set linesize 333 col sql_text format a88
2014-05-29 10:54:28 629
转载 Scripts:查看回滚的SQL的脚本 huigun.sql
select STATE,UNDOBLOCKSDONE,PID,XID from v$fast_start_servers; alter session set nls_date_format='yyyy-mm-dd hh
2014-05-29 10:54:18 944
Orapub System Monitor
2015-06-17
Oracle Core:Essential.Internals.for.DBAs.and.Developers.Jonathan.Lewis
2012-08-13
Using.Oracle.Solutions.on.Linux.for.System.z.2008
2012-08-04
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人