你确定是sql的问题?导致ora-03113 错误的因素多的要命!
先不要那么早下断言,看看出错的数据库中
alertSID.log 里面有什么信息。贴上来!
先不要那么早下断言,看看出错的数据库中
alertSID.log 里面有什么信息。贴上来!
解决方案 »
- 求SQL语句
- HQL count(*)和 fetch 的问题
- 求一个算日期的方法。
- Oracle 相除的语法问题
- !!!!哪位高手能帮忙解下这两道Oracle题,
- 问一个比较弱质的问题啊,.Net开发的时候,装了oracle data provider for .net 还需要装Orcle客户端吗?
- 简单问题,怎么知道自己用户的权限
- trigger table or view does not exists问题!!!
- 请大家帮忙看一个问题:为什么存储过程执行如此不稳定呢?
- 求图表工具(言者有分)
- 帮忙!!!acess数据库查询语句,转换为oracle数据库查询语句!在线等!
- oracel简单统计问题,统计今年数据和去年同期数据
Action If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.
Rule-based optimization never uses function-based indexes.
2. Check, whether all required tables are analyzed for gathering statistics for the optimizer, otherwise the indexes cannot be used to process sql statements.
3. If the status of the function based index is disabled, the index will be disabled by any changes to the function specification.
SQL> select index_name,index_type,status from user_indexes where index_name='<index_name>';
INDEX_NAME INDEX_TYPE STATUS
--------------- --------------------------- --------
FB_X FUNCTION-BASED NORMAL VALID
4. For optimizer to choose the function-based index, the following
session/init.ora variables need to be set.
QUERY_REWRITE_ENABLED = TRUE
QUERY_REWRITE_INTEGRITY = TRUSTED
for example:
~~~~~~~~~~~~
SQL> ALTER SESSION SET query_rewrite_enabled=true;
SQL> ALTER SESSION SET query_rewrite_integrity=trusted;If all the above is set properly, then you might be hitting the following bug: [BUG:902521] FUNCTION BASED INDEX ON TRUNC(DATECOLUMN) IS NEVER USED
[BUG:933439] Functional bitmap indexes on BITAND / DATE do not work properly
1、不建函数索引,对items_date建索引,然后使用
items_date >= to_date( '2004-11-17 00:00:00' , 'yyyy-mm-dd hh24:mi:ss' ) and
items_date <= to_date( '2004-11-17 23:59:59' , 'yyyy-mm-dd hh24:mi:ss' ) 来查询
2、对items_data 建to_char( items_date , 'yyyy-mm-dd' ) 的索引,
使用 to_char( items_date , 'yyyy-mm-dd' ) = '2004-11-17' 来查询
还有就是 "我建了一个trunc(items_date)的函数索引,items_operator_no列上也建了一个索引"
对同一个表查询时,不会同时用到两个索引的,所以你的程序要么用到items_operator_no的索引,
要么用到trunc(items_date)的函数索引