Syed Saad Ali

Oracle ACE Associate

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Associate

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Scripts

October 11, 2017 How to Find CPU Usage for a Session
Database ScriptsScripts

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

October 10, 2017 Query To find the details of the Accounting Flexfield structure
AppsDBA ScriptsConfigurations-GLScripts

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 …

October 1, 2017 How To Move Table to Different TableSpace
APPS DBAAppsDBA ScriptsDatabase ScriptsScripts

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);  

September 1, 2017 Undo Related Queries Part 2
APPS DBAAppsDBA ScriptsScripts

List of All active Transactions