2008年
-
编辑 删除
SESSION_CACHED_CURSORS test
SESSION_CACHED_CURSORS: If an application repeatedly issues parse calls on the same set of SQL statements, then the reopening of the session cursors can affect system performance. To minimize the impa...
-
编辑 删除
Migrate from 9i to 10g by using transport tablespace feature
Migrate 9i db to 10g quickly by using transport tablespace features.Below is test steps.1. check self contained of tablespaceEXECUTE DBMS_TTS.TRANSPORT_SET_CHECK('ALAMEDA_DATA', TRUE);SELECT * FROM...
