ORA-01037: Cause: An attempt was made to process a complex SQL statement which consumed all available memory of the cursor.Action: Simplify the complex SQL statement. Alternatively, you can use the NO_EXPAND hint which prevents the cost-based optimizer from considering OR-expansion for queries having OR conditions or INLISTS in the WHERE clause. Usually, the optimizer considers using OR expansion and uses this method if it decides the cost is lower than not using it. Refer to Oracle8i Designing and Tuning for Performance for information about using hints.(It's not a OCP question)
能介绍一点学ORACLE的经验吗!
[email protected]
还是在合肥上的学?
我的邮箱:[email protected]
sologzh(沙沙)
什么操作,出现这样的错误
我也想学习ORACLE,可手头上没什么资料!
有什么好的书可以学习的呢?!
Cause: An attempt was made to process a complex SQL statement which consumed all available memory of the cursor.Action: Simplify the complex SQL statement. Alternatively, you can use the NO_EXPAND hint which prevents the cost-based optimizer from considering OR-expansion for queries having OR conditions or INLISTS in the WHERE clause. Usually, the optimizer considers using OR expansion and uses this method if it decides the cost is lower than not using it. Refer to Oracle8i Designing and Tuning for Performance for information about using hints.(It's not a OCP question)
另外,可否把你考OCP的感想整理整理,让大家分享一下,学习一下。毕竟OCP还是较难考的,也让很多人向往,我也想考,但又不了解......
[email protected]
拜托拜托。