backup SERVER 数据是从生产机器上exp 再imp 的, 数据一样.
先谢了!
先谢了!
解决方案 »
- oracle 主表和子表的语句
- 一个触发器的问题(急)
- 花钱让Oracle同仁们给我解决Oracle的作业
- 紧急求助,oracle9连接oracle7的问题,100分求助。
- sql中有没有测试字符串包含的查询子句
- 动态存储过程,难,高手过来看看.............
- oracle查询语句中的取位问题
- oracle无法与WinGate共存的解决方法
- ER 模型的几个问题,麻烦高手帮我解释一下!
- 为什么我进不了SQL*PLUS???
- oracle 高手来看看这个死锁问题。(多线程往数据库中查询ID,如果查询不到根据输入创建一条记录,并返回对应ID)
- oracle自带的ultra search如何进行中文分词?
正式环境
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 VIEW
2 1 COUNT (STOPKEY)
3 2 FILTER
4 3 MERGE JOIN
5 4 SORT (JOIN)
6 5 NESTED LOOPS
7 6 TABLE ACCESS (FULL) OF 'DBMS_DISTRIBUTOR_REGIO
N' 8 6 TABLE ACCESS (BY INDEX ROWID) OF 'DISTRIBUTOR_
INFO' 9 8 INDEX (UNIQUE SCAN) OF 'PK_DBMS_DISTRIBUTOR_
INFO' (UNIQUE) 10 4 SORT (JOIN)
11 10 TABLE ACCESS (FULL) OF 'DBMS_CUSTOMER_INFO'
12 3 INDEX (UNIQUE SCAN) OF 'DBMS_USER_REGION_PK' (UNIQUE
) 13 3 INDEX (UNIQUE SCAN) OF 'DBMS_USER_REGION_PK' (UNIQUE
) 14 3 INDEX (UNIQUE SCAN) OF 'DBMS_USER_REGION_PK' (UNIQUE
)Statistics
----------------------------------------------------------
8 recursive calls
101 db block gets
1843 consistent gets
983 physical reads
0 redo size
6471 bytes sent via SQL*Net to client
758 bytes received via SQL*Net from client
5 SQL*Net roundtrips to/from client
1 sorts (memory)
1 sorts (disk)
51 rows processed16:57:10 16:57:10
==========================================================================================
备份环境
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 VIEW
2 1 COUNT (STOPKEY)
3 2 FILTER
4 3 MERGE JOIN
5 4 SORT (JOIN)
6 5 NESTED LOOPS
7 6 TABLE ACCESS (FULL) OF 'DBMS_DISTRIBUTOR_REGIO
N' 8 6 TABLE ACCESS (BY INDEX ROWID) OF 'DISTRIBUTOR_
INFO' 9 8 INDEX (UNIQUE SCAN) OF 'PK_DBMS_DISTRIBUTOR_
INFO' (UNIQUE) 10 4 SORT (JOIN)
11 10 TABLE ACCESS (FULL) OF 'DBMS_CUSTOMER_INFO'
12 3 INDEX (UNIQUE SCAN) OF 'DBMS_USER_REGION_PK' (UNIQUE
) 13 3 INDEX (UNIQUE SCAN) OF 'DBMS_USER_REGION_PK' (UNIQUE
) 14 3 INDEX (UNIQUE SCAN) OF 'DBMS_USER_REGION_PK' (UNIQUE
)Statistics
----------------------------------------------------------
961 recursive calls
286 db block gets
2121 consistent gets
974 physical reads
20060 redo size
6471 bytes sent via SQL*Net to client
758 bytes received via SQL*Net from client
5 SQL*Net roundtrips to/from client
1 sorts (memory)
1 sorts (disk)
51 rows processed16:58:59 16:58:59
redo size
这个大不同,这是不是问题所在?
开发商开发的软件过度频繁的插入删除
你用exp导出再用imp导入就可以清除碎片了
当然先把外围的应用程序全部关了
在生产机器上exp imp到另外一个用户也试过了,没啥效果
但是我用同样的方法去分析另为一个表,导致ORACLE 占用内存不断加大,老师占用CPU %2-5%
能不能指点下在ORACLE 8.17上, analyze table table_name compute statistics ,要注意些什么?
为什RUN后产生两种不同的效果。