-
编辑 删除
SQL Tuning Advisor
SQL Tuning Advisor 数据库环境：oracle11gr2 数据库用户OE下面的表prootab数据量150万条记录数，执行全表扫描。 [@more@]1. 要访问SQL tuning advisor API，必须给一个用户授予 ADVISOR权限。 CONN sys/password AS SYSDBA GRANT ADVISOR TO dbmaintain; CONN dbmaintain/dbmaintain 2. 使用dbms_sqltune.create_tunning_task创建优化任务 SET SERVEROUTPUT ON -- Tuning task created for specific a statement from the AWR. --从AWR指定一个语句(SQL_ID)为了创建调优任务. DECLARE l_sql_tune_task_id VARCHAR2(100); BEGIN l_sql_tun
-
编辑 删除
ora-03113 错误解决方法
环境：windows 2003 32bit 、oracle 9.2.0.1、oracle 9.2.0.8今天开发公司开发人员在9.2.0.1或9.2.0.8均执行下面sql语句报错:ora-03113:通信通道文件结束SQL如下:[@more@](select * from((select obj.*,priv.applictionId as appId,role.actionMode,role.actionIndexsfrom g_objectaction role, G_Privilege priv, G_ObjectSet objwhere priv.userid = 'FENGM'and priv.tag = 0and role.roleId = priv.roleidand role.objectid = obj.id)union(select obj.*, priv.APPLICTIONID, priv.actionMode, priv.actionIndexsfrom G_ObjectSet obj,
