delete

Undocumented parameters of database

SELECT X.KSPPINM NAME, DECODE(BITAND(KSPPIFLG/256, 1), 1, 'TRUE', 'FALSE') SESMOD, DECODE( BITAND(KSPPIFLG/65536, 3), 1, 'IMMEDIATE', 2, 'DEFERRED', 3, 'IMMEDIATE', 'FALSE' ) SYSMOD, KSPPDESC DESCRIPTION FROM SYS.X_$KSPPI X WHERE X.INST_ID = USERENV('INSTANCE') AND TRANSLATE(KSPPINM,'_','#') LIKE '#%' ORDER BY 1
delete

Simple SQL*Plus script for rebuild of in...

In older versions of Oracle I sometimes faced problem of corupted or too fragmented indexes. In such case you need to rebuild them. But be careful this operation can be very time consuming and no one should work in database – if possible do it in restrict mode. Here is very simple script for SQL*Plus which will do it: </pre> set define off set serveroutput on spool rebuild_dsu.log prompt Starting RE-BUILD of existing indexes BEGIN FOR INDEX_RECORD IN (select owner||'.'||object_name as obj from dba_objects where object_type = 'INDEX' and owner...