没有合适的资源?快使用搜索试试~ 我知道了~
如何优化oracle数据库性能.pdf
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 89 浏览量
2021-10-02
14:37:51
上传
评论
收藏 181KB PDF 举报
温馨提示
试读
27页
如何优化oracle数据库性能.pdf
资源推荐
资源详情
资源评论
1. Oracle
Oracle 3
a.RULE( )
b.COST( )
c.CHOOSE( )
init.ora OPTIMIZER_MODE
RULE COST CHOOSE ALL_ROWS FIRST_ROWS SQL
(session)
(CBO Cost-Based Optimizer)
analyze (object statistics)
(CHOOSE)
analyze table analyze CBO
RULE
Oracle CHOOSE (full
table scan) CHOOSE
2. Table Oracle
a.
Oracle (database
block)
b. ROWID
ROWID ROWID
Oracle (INDEX)
(ROWID) ROWID
3. SQL
SQL Oracle SQL
SGA(system global area) (shared buffer pool)
SQL (
) Oracle
Oracle SQL
Oracle (cache buffering)
init.ora
Oracle SQL Oracle
Oracle SQL
( )
A.
SELECT * FROM EMP;
SELECT * from EMP;
Select * From Emp;
SELECT * FROM EMP;
B.
Jack sal_limit private synonym
Work_city public synonym
Plant_detail public synonym
Jill sal_limit private synonym
Work_city public synonym
Plant_detail table owner
SQL
SQL
select max(sal_cap) from sal_limit private synonym -
sal_limit
select count(*0 from work_city where sdesc like 'NEW%'
public synonym - work_city
select a.sdesc b.location from work_city a plant_detail b where a.city_id
= b.city_id jack private synonym plant_detail jill
C. SQL (bind variables)
SQL ( )
( )
a.
select pin name from people where pin = blk1.pin;
select pin name from people where pin = blk1.pin;
b.
select pin name from people where pin = blk1.ot_ind;
select pin name from people where pin = blk1.ov_ind;
4. ( )
Oracle FROM FROM
( driving table) FROM
Oracle
(FROM )
(FROM )
TAB1 16 384
TAB2 1
TAB2 ( )
select count(*) from tab1 tab2 0.96
TAB2 ( )
select count(*) from tab2 tab1 26.09
3 (intersection table)
EMP LOCATION CATEGORY
SELECT *
FROM LOCATION L
CATEGORY C
EMP E
WHERE E.EMP_NO BETWEEN 1000 AND 2000
AND E.CAT_NO = C.CAT_NO
AND E.LOCN = L.LOCN
SQL
SELECT *
FROM EMP E
LOCATION L
CATEGORY C
WHERE E.CAT_NO = C.CAT_NO
AND E.LOCN = L.LOCN
AND E.EMP_NO BETWEEN 1000 AND 2000
5. WHERE
Oracle WHERE
WHERE WHERE
( 156.3
SELECT
FROM EMP E
WHERE SAL > 50000
AND JOB = MANAGER
AND 25 < (SELECT COUNT(*) FROM EMP
WHERE MGR=E.EMPNO);
( 10.6 )
SELECT
FROM EMP E
WHERE 25 < (SELECT COUNT(*) FROM EMP
WHERE MGR=E.EMPNO)
AND SAL > 50000
AND JOB = MANAGER
6.SELECT *
SELECT COLUMN SQL *
Oracle
*
7.
SQL Oracle SQL
Oracle
0342 0291
1( )
SELECT EMP_NAME SALARY GRADE
FROM EMP
WHERE EMP_NO = 342;
SELECT EMP_NAME SALARY GRADE
FROM EMP
WHERE EMP_NO = 291;
2( )
DECLARE
CURSOR C1 (E_NO NUMBER) IS
SELECT EMP_NAMESALARYGRADE
FROM EMP
WHERE EMP_NO = E_NO;
BEGIN
OPEN C1(342);
FETCH C1 INTO .. .. ;
OPEN C1(291);
剩余26页未读,继续阅读
资源评论
资料大全
- 粉丝: 14
- 资源: 26万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功