CREATE TABLESPACE "apps" DATAFILE '/db/oradata/apps01.dbf' SIZE 1000M, '/db/oradata/apps02.dbf
isql does not support connecting to a named instance of SQL Server 2000. If no server is specified,
以下是目录： Active Transactions in Rollback Segments Best Tablespace Utilization Report by
以下是目录： Active Transactions in Rollback Segments Best Tablespace Utilization Report by Far Bu
性能相关内容 1、捕捉运行很久的SQL column username format a12 column opname format a16 column progress
1、查看表空间的名称及大小 select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size from dba_tablespace
1. 监控事例的等待 select event,sum(decode(wait_Time,0,0,1)) "Prev", sum(decode(wait_Time,0,1,0)) "C
1、查看表空间的名称及大小 select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size from dba_tab
SQL语句： 表： select * from cat; select * from tab; select table_name from user_tables; 视图：
1.监控事例的等待： select event,sum(decode(wait_time,0,0,1)) prev, sum(decode(wait_time,0,1,0)) cur