Displaying 2 results from an estimated 2 matches for "pctfree".
2004 Nov 22
3
Mode context extremely poor performance.
...E}_${SEX} (RECH_CRITERES)
indextype is ctxsys.context PARAMETERS ('MEMORY 50M STORAGE
text_storage')
/
with:
-----
BEGIN ctx_ddl.create_preference('SYS.TEXT_STORAGE',
'BASIC_STORAGE'); ctx_ddl.set_attribute('SYS.TEXT_STORAGE',
'I_INDEX_CLAUSE',
'pctfree 0 tablespace TBS_SNAP_INDEX');
ctx_ddl.set_attribute('SYS.TEXT_STORAGE', 'I_ROWID_INDEX_CLAUSE',
'pctfree 0 tablespace TBS_SNAP_INDEX');
ctx_ddl.set_attribute('SYS.TEXT_STORAGE', 'I_TABLE_CLAUSE',
'pctfree 0 tablespace TBS_SNAP_INDEX...
2004 Nov 22
3
Mode context extremely poor performance.
...E}_${SEX} (RECH_CRITERES)
indextype is ctxsys.context PARAMETERS ('MEMORY 50M STORAGE
text_storage')
/
with:
-----
BEGIN ctx_ddl.create_preference('SYS.TEXT_STORAGE',
'BASIC_STORAGE'); ctx_ddl.set_attribute('SYS.TEXT_STORAGE',
'I_INDEX_CLAUSE',
'pctfree 0 tablespace TBS_SNAP_INDEX');
ctx_ddl.set_attribute('SYS.TEXT_STORAGE', 'I_ROWID_INDEX_CLAUSE',
'pctfree 0 tablespace TBS_SNAP_INDEX');
ctx_ddl.set_attribute('SYS.TEXT_STORAGE', 'I_TABLE_CLAUSE',
'pctfree 0 tablespace TBS_SNAP_INDEX...