以下数据来源于TRDIR,TRDIRT,有一些对应系统的事务,有具体的T-CODE.以下我会标注一些我个人认为会常用到的.
程序 | 功能描述 |
RSORA000 | ORACLE 监视器 |
RSORA001 | Oracle 数据库的安装参数 |
RSORA002 | Oracle数据库的系统统计信息 |
RSORA003 | 对Oracle数据库物理访问的统计信息 |
RSORA003N | Statistics of Physical Accesses to Oracle Database |
RSORA004 | 实际数据库锁定 |
RSORA005 | 系统Oracle数据库V$SGA的全局域 |
RSORA006 | 字典超高速缓冲寄存器的统计 |
RSORA007 | 数据库等待情况的统计 |
RSORA008 | 重算段统计 |
RSORA009 | 存取及寄存器等待时间 |
RSORA00D | Direct call of submonitors (new entry design) |
RSORA00E | DB-ORA-Monitor: New Entry Design |
RSORA010 | 门闩保持者 |
RSORA011 | 实际数据库进程 |
RSORA012 | 资源上的锁 |
RSORA013 | 访问表 |
RSORA014 | Transactions |
RSORA015 | 后台处理 |
RSORA016 | 词典超高速缓冲存储器统计 |
RSORA01E | DB-ORA-Monitor: New Entry Design |
RSORA022 | Monitor One Data Base Session |
RSORA030 | |
RSORA031 | 寄存器的等待情况 |
RSORA032 | 寄存器的等待 |
RSORA040 | 存取及寄存器等待时间 |
RSORA050 | ST04 (Oracle): Resource Consumption by R/3 Client |
RSORA060 | DB02 (Oracle): 主程序 |
RSORA070 | Oracle数据库的系统统计信息 |
RSORA077 | 会话监视器,oracle session 可以用STO4然后选择oracle session |
RSORA083 | Display History of Database Calls (ST04: Previous Days) |
RSORA085 | 数据库性能概要 |
RSORA100 | 解释计划的子程序 |
RSORA108 | Statistics of Rollback Segments |
RSORA110 | 显示 SAP, OS 和 DB 参数修改 |
RSORA122 | 对序列文件的 AMDS 内容 |
RSORA130 | 来自控制文件的数据文件信息 |
RSORA131 | 控制文件中的系统记录文件资料 |
RSORA132 | 有关重做日志文件的信息 |
RSORA133 | 在数据库里为EACH线索存档标志信息 |
RSORA134 | 多线信息队列信息 |
RSORA135 | 来自控制文件中的数据库信息 |
RSORA136 | 关于控制文件的日志历史信息 |
RSORA137 | 列出活动会话等待的资源/事件 |
RSORA138 | 每个用户对话的 IO 状态(ORA7 V$SESS_10) |
RSORA139 | 在几百秒内的当前时间 |
RSORA140 | 显示所有修理表,视图和数据库派生表 |
RSORA141 | 当前远程状态(V$远程) |
RSORA142 | 有关许可证极限的信息 |
RSORA143 | 为完全媒体恢复存档标志被需要 |
RSORA144 | 文件状态需要媒体恢复 |
RSORA145 | 共享光标缓冲 |
RSORA146 | 列出活动会话等待的资源/事件 |
RSORA147 | ST04: Shared Cursor Cache (V$SQL) |
RSORA148 | 从控制文件中的螺纹资料 |
RSORA149 | 调度程序处理的信息 |
RSORA150 | 被授予特权 |
RSORA151 | Cursor Each User Session Currently Opened and Parsed |
RSORA152 | ORACLE 7.0 在MULTI-THREAD 信息队列的信息 |
RSORA153 | 请求时间历史图表 |
RSORA154 | VIRTRAL CLRCUIT 的信息(ORA7 V$CIRCUIT) |
RSORA156 | 数据库目标超高速缓冲存储于库缓冲存储器 |
RSORA158 | 库超高速缓冲寄存器统计 |
RSORA159 | 对话信息 |
RSORA160 | 在几百秒内的当前时间 |
RSORA161 | 显示 V$COMPATIBILITY |
RSORA162 | V_$COMPATSEG |
RSORA164 | V_$INSTANCEX |
RSORA165 | V_$KCBCBHX |
RSORA166 | V_$KCBRBHX |
RSORA167 | V_$LATCH |
RSORA168 | V_$LE_STATX |
RSORA169 | V_$NLS VALUES |
RSORA170 | V_$OPTION |
RSORA171 | V_$PQ_SESSTAT |
RSORA172 | V_$PQ_SLAVE |
RSORA173 | V_$PQ_SYSSTAT |
RSORA174 | V_$WAITSTATX |
RSORA175 | V_$transaction |
RSORA176 | V_$WAITSTATX |
RSORA180 | V$DB_PIPES |
RSORA181 | V$event_name |
RSORA182 | V$Executtion |
RSORA183 | V$Fixed_View_Definition |
RSORA184 | V$Latch_children |
RSORA185 | V$Latch_parent |
RSORA186 | V$Object_dependency |
RSORA187 | V$Describe_session_info |
RSORA189 | V$System_Event: System Waits Statistics |
RSORA190 | V$Controlfile: Control File Information |
RSORA191 | V$Locked_Object: Locked Object Information |
RSORA192 | ST04 (Oracle): Buffer Fragmentation (X$KSMSP) |
RSORA193 | ST04 (Oracle): Filewaits x$kcbfwait |
RSORA200 | Display V$locked_object |
RSORALCK | Program RSORALCK,与RSORA200运行结果相同,只不过显示风格不一样,整重了 |
RSORA201 | v$lock_activity ECC6.0的数据库不存在这个视图 |
RSORA202 | v$ping 没试出来什么意思? |
RSORA203 | statistic of pinged objects |
RSORA204 | False pinging |
RSORA245 | 共享光标缓冲 |
RSORA250 | ST04 (Oracle): Wait Events (V$System_Event/V$Session_Event) |
RSORA300 | List of all appl.server + DB instances |
RSORA800 | 开始完成数据库备份, 旧的报表, 将被删除! |
RSORA801 | 用-V参数启动 BrBackup,使用外部程序接口 |
RSORA805 | 打印日常恢复报表; !!! 旧报表, 将被删除!!! |
RSORA811 | 删除旧的Br备份/Br档案日志 (SDBAH 和 SDBAD) |
RSORA820 | 专家的描述文件管理 br备份 |
RSORA850 | 显示备份日志,未试 |
RSORA999 | 显示物理访问Oracle文件的统计信息 |
RSORAADM | 用于 Oracle 的数据库管理和备份计划 |
RSORABUF | RSORABUF: Display of Buffer Pool Information for V$ Tables |
RSORACBO | Analysis for Cost-Based Optimizer (Belongs to DB02),表和索引 |
RSORACHK | Import of Checkpoints |
RSORACMP | Mini-compiler for OPS |
RSORACOL | Oracle monitoring: DB02 collector |
RSORACUP | Oracle monitoring: add/remove database connections |
RSORADBA | SAPDBA 的 ORACLE-相关格式 |
RSORADDL | RSORADDL: Create Statement |
RSORADEL | Oracle monitoring: deleta moni entries |
RSORADIS | Display,(不明) |
RSORADJV | 可以输入SQL语句进行查询,类似于sqlplus ,可以执行类似于select * from v$lock; |
RSORAENV | ST04 (Oracle): Display Environment Parameters for Selected Host |
RSORAFAL | Oracle monitoring: Alter contains of dba_segments |
RSORAHCL | History collector for oracle database monitors |
RSORAHST | Oracle DB statistics history: Take snapshot + reorg snapshots |
RSORAINI | Oracle Monitor: Initialization |
RSORAISQ | Index Storage Quality Management for Oracle |
RSORAISQN | Index Storage Quality Analysis |
RSORAMAM | external performs for OPS |
RSORAMDB | Test Program for Creating a Second Database Connection |
RSORAOPS | OPS subroutines |
RSORAPATCHINFO | List of installed Oracle patches |
RSORARAC_MAIN | Display ST04 Data from Oracle Procedures |
RSORAS30 | Exclusive Lockwaits,lock 的高级显示,可以查看V$LOCK |
RSORASEL | ST04 (Oracle): Performance Test of WHERE Clause |
RSORASES | Information about an Oracle Session |
RSORASNP | 改组SNAPS和STAT$表 |
RSORASPF | Database Parameters Configuration,需要basis权限 |
RSORASQL | Test Program,分析数据库性能,共享指针,与oracle session 监控相似,可以看到SQL的执行计划 |
RSORASSC | V$SEGSTAT monitor in collector mode |
RSORASSM | Program RSORASSM,可以统计数据库启动以后表的读取次数,频率 |
RSORASSM_TESTING | Program RSORASSM_TESTING |
RSORASTM | Program ZJBORADEVST |
RSORAT02 | To be deleted (T.S. 6/97) |
RSORAT0D | Include LSTERM_MULTIF02 |
RSORATAB | DB02 (Oracle): Tables and Indexes: Detailed Analysis (Report) |
RSORATAC | Tables and Indexes: Submit ANALYZE TABLE/INDEX |
RSORATAD | Analysis of Index 'Storage Management Quality' |
RSORATB4 | ?... |
RSORATBM | 历史 ORACLE TABLESPACES |
RSORATC3 | ?... |
RSORATC5 | DB02 (Oracle): Checks: Extents of Tables and Indexes (Not Used > 31G) |
RSORATC8 | List of all table DB blocks |
RSORATCA | 检查下一个程度大小是否小于上月内的增长 |
RSORATCO | DB02 (Oracle): Checks: Analysis for Cost-Based Optimizer |
RSORATD1 | to be deleted! Use function 'DB02_ORA_FILL_TS_CHECK__CRITOB' instead! |
RSORATED | Analysis of multiple indexes storage quality |
RSORATOOLS | Display DDL Statement:获得一个表或索引的数据定义语言(DDL) |
RSORATRC | Switch Oracle Trace On and Off |
RSORATRP | ST04 (Oracle): Trap for SQL Statements |
RSORAUD0 | Update entries from MONI table |
RSORAUD1 | Update entries from MONI table |
RSORAUD2 | Update entries from MONI table |
RSORAUND | V$UNDOSTAT Statistics Monitor. |
RSORAV2C | ST04 (Oracle): Check of V2*Net Installation |
RSORAV2N | ST04 (Oracle): Display sqlnet.ora, listener.ora, protocol.ora |
RSORAVDV | V$-Tables (Oracle) |
RSORAVSE | History of Table V$SYSTEM_EVENT (Oracle) |
RSORAVSH | Report for Collecting Data from V$SYSTEM_EVENT Hourly |
RSORAWTI | Fast Access to Exclusive Lock Wait Situations |
RSORA_AL11 | Display the ORACLE_HOME Directory (Changed from 8.1.6) |
RSORGTAB | 实体表联系清单,这个执行太慢了. |
RSORMN00 | Update Statistics for Certain Index |
RSCLTCOP | Copy tables across clients |
RSAVGL00 | Table adjustment across clients |
RSINCL00 | Extended program list |
RSBDCSUB | Release batch-input sessions automaticly |
RSTXSCRP | Transport SAPscript files across systems |
RSORAREL | Get the Oracle Release |
RGUGBR00 | Substitution/Validation utility |
RSPARAM | Display all instance parameters |
RSUSR003 | Check the passwords of users SAP* and DDIC in all clients |
RSUSR006 | List users last login |