Re: ��oracle��sql trace

Article View: cn.bbs.comp.database

Article #8992

Back to cn.bbs.comp.database Previous Next

#8992

From: jerry
Date: Mon, 15 Sep 2003 07:03

28 lines
2732 bytes

����sql����ִ��ʱ����sql*plus������set timing on��������
�������������һֱ�򿪿�����?/sqlplus/admin/glogin.sql����
�ӡ�
sql trace��Ҫ��������ִ�мƻ��ģ�����ʹ��cbo or rbo��ʹ��fts
���߻���ͨ��index������ݵȵȣ����Ը��trace��ִ�мƻ���tuning
������tkprof��9i�е�Ȼ�����еģ�$ORACLE_HOME/BIN���档
����sql trace������alter session set sql_trace=true��sql*plus
��ֱ��set autotrace on֮�⣬����������10046 event�����ã�
�ܶ�tuning��ʱ������10046 event ��trace��
alter session set events '10046 trace name context forver,level 12';
10046 event�����кܶ����ϣ�google����һ�¾��кܶࡣ

�� �� vgl (�ɹ�ʧ�����Լ�����̨�����׷��) �Ĵ������ᵽ: ��
: ��oracle 8i���������һ��tkprof����鿴trace�ļ���
: ����oracle9i�������û����������trace�ļ��ҿ�����
: ���������õ���sql����ܵ�ִ��ʱ�䣬���������trace�ļ���
: ���ĸ����� ��л��
: *** 2003-09-13 11:43:33.000
: *** SESSION ID:(11.27) 2003-09-13 11:43:33.000
: APPNAME mod='SQL*Plus' mh=3669949024 act='' ah=4029777240
: =====================
: PARSING IN CURSOR #1 len=41 dep=0 uid=59 oct=42 lid=59 tim=8725374744 
: hv=19920
: .................������ʡ�ԣ�

--
��ؼ�������漣
[m[1;32m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 210.5.28.2][m

Technical Details

Message-ID: <48HJdW$bOa@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!216.170.153.135.MISMATCH!tdsnet-transit!newspeer.tds.net!205.215.62.125.MISMATCH!in.100proofnews.com!in.100proofnews.com!irazu.switch.ch!switch.ch!newsfeed00.sul.t-online.de!t-online.de!news.neu.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Language: Chinese,GB
X-Google-Thread: 101948,d6af6849d67450df
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-09-19 03:38:14 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!216.170.153.135.MISMATCH!tdsnet-transit!newspeer.tds.net!205.215.62.125.MISMATCH!in.100proofnews.com!in.100proofnews.com!irazu.switch.ch!switch.ch!newsfeed00.sul.t-online.de!t-online.de!news.neu.edu.cn!SJTU
From: jerrysun.bbs@bbs.sjtu.edu.cn (jerry)
Newsgroups: cn.bbs.comp.database
Subject: Re: ���oracle��sql trace
Date: 15 Sep 2003 07:03:59 GMT
Organization: ��ˮ˼Դ
Message-ID: <48HJdW$bOa@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1063608944.A
Lines: 28

Article View: cn.bbs.comp.database

Re: ���oracle��sql trace

Re: ��oracle��sql trace