Scripts
How to Find CPU Usage for a Session
SET linesize 145
SET pagesize 9999
COLUMN sid format 9999 heading ‘SID’
COLUMN serial_id format 999999 heading ‘Serial#’
COLUMN session_status format a9 heading ‘Status’ justify right
SELECT gls.name,
idfs.id_flex_num chart_of_accounts_id,
idfs.segment_num,
idfs.flex_value_set_id,
fvs.flex_value_set_name,
idfs.application_id,
idfs.id_flex_code,
idfs.application_column_name,
idfs.segment_name,
fvs.security_enabled_flag,
( CASE
WHEN fvs.validation_type = ‘F’ THEN ‘Table’
WHEN fvs.validation_type = ‘I’ THEN ‘Independent’
WHEN fvs.validation_type = ‘D’ THEN ‘Dependent’
WHEN fvs.validation_type = ‘N’ THEN ‘None’
WHEN fvs.validation_type = ‘P’ THEN ‘Pair’
WHEN fvs.validation_type = ‘U’ THEN ‘Special’
ELSE ‘Unknown Type’
END ) validation_type,
( CASE
WHEN fvs.validation_type = ‘F’ THEN fvt.application_table_name
ELSE ‘Not Applicable’
END ) validation_table_name
FROM gl_ledgers gls,
fnd_id_flex_segments idfs,
fnd_flex_value_sets fvs,
fnd_flex_validation_tables fvt
WHERE gls.chart_of_accounts_id (+) = idfs.id_flex_num
AND fvs.flex_value_set_id = idfs.flex_value_set_id
AND gls.ledger_id = &ledgerid
AND idfs.application_id = 101
AND idfs.id_flex_code IN ( ‘GL#’, ‘GLLE’ )
AND fvs.flex_value_set_id = fvt.flex_value_set_id (+)
ORDER BY idfs.id_flex_code,
idfs.id_flex_num,
idfs.segment_num ASC;
How To Move Table to Different TableSpace
SYNTAX
ALTER TABLE table_name move TABLESPACE tablespace_name (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);
EXAMPLE
ALTER TABLE hr.employee_details move TABLESPACE hr;
OR
ALTER TABLE hr.employee_details move TABLESPACE hr (INITIAL=64k MINEXTENTS=1 MAXEXTENTS=UNLIMITED);