|
# 42638
Chi
来自: Mexico
|
|
|
 To: Eygle
I found the solution.
By reviewing a reference about the large_pool_size, it suggested that "alter system set disk_asynch_io=FALSE scope=spfile;" may help to speed up the RMAN, so i did and "alter system set large_pool_size=32M;". Tried a partial and a full database incremental level 0 and 1 backup, and it worked much faster now to finished my 32G database. The only question I concern is about whether the change of the asynch IO will affect other processes in Oracle. I maintain the same aio0 configuration on OS level.
From: Chi
2007.01.20 07:47
|
|
|
|
|
# 42634
Chi
来自: Mexico
|
|
|
To: Eygle
According to the result of the Backup Reports of the EM control (web form), the output rate varied from 11k up to 700K.I will tried to take out the "compressed". I also found on web that someone mentioned the slow of RMAN due to the setting of the AIX aio0 (asynchronous I/O), checked by the lsattr -El aio0.However, I did not know what is the proper values for AIX 5.3L, a lcpu=4 smt enabled, 4 HDs, p550 machine.Each change needs reboot the box
From: Chi
2007.01.18 05:20
|
|
|
|
|
# 42633
oracle 初段
|
|
|
To:
盖老师：
我想问问关于这个排序的问题，如果我查询的数据量不大，完全可以在通过内存排序来完成，那么查询结果返回给我是从buffer cache读的数据还是直接从排序区中读的数据呢？oracle在进行排序时，是把整个的数据块读到内存，我这样理解对吗？
2 ,共享池中的dictionary cache 中存放的是一些什么信息？
期待回答！谢谢
From: oracle 初段
2007.01.17 16:13
|
|
|
 |
|
 |
 |
|
 |
|
|
To: oracle 初段
从PGA，排序在你的PGA中完成，你测试一下就能明白多一点:
SQL> create table t as select * from dba_users;
Table created.
SQL> alter session set events '10046 trace name context forever,level 12';
Session altered.
SQL> select * from t order by username;
PARSING IN CURSOR #1 len=68 dep=0 uid=0 oct=42 lid=0 tim=18134204370315 hv=1346161232 ad='e554cd0'
alter session set events '10046 trace name context forever,level 12'
END OF STMT
EXEC #1:c=0,e=25758,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=18134204359003
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 7431559 p1=1650815232 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=33 dep=0 uid=0 oct=3 lid=0 tim=18134211823578 hv=1202041768 ad='106e4fe0'
select * from t order by username
END OF STMT
PARSE #1:c=0,e=21119,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=18134211823565
BINDS #1:
EXEC #1:c=0,e=218,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=18134211823977
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1650815232 p2=1 p3=0
WAIT #1: nam='db file sequential read' ela= 56 p1=1 p2=26514 p3=1
FETCH #1:c=0,e=454,p=1,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=18134211824551
WAIT #1: nam='SQL*Net message from client' ela= 1992 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1650815232 p2=1 p3=0
FETCH #1:c=0,e=121,p=0,cr=0,cu=0,mis=0,r=14,dep=0,og=4,tim=18134211826802
dictionary cache 的内容随便文档上都有讲。
From: eygle
2007.01.17 17:15
|
|
|
 |
|
 |
|
|
eygle.com
我要留言
回复
编辑
