The following SQL script, when run as user SYS, will generate an ordered script to recreate all the java grants, and java policies, assigned to users. It does not generate…
Read MorePlease find the steps done below for one type of block but can be used for any block. create table demo.wcc99(n number, c varchar2(4000)) nologging tablespace DISC pctfree 99…
Read MorePlease run the below command from <Agent base>/agent_inst/bin of the agent monitoring the target host. ./emctl config agent addinternaltargets ./emctl secure agent ./emctl config agent listtargets ./emctl stop agent ./emctl secure agent…
Read Moreset verify off set feedback off set lines 300 set pages 0 set heading off set space 0 column text format a79 column line noprint select DECODE(line,1,’create or replace ‘,”)||text,…
Read MoreSPO sql_performance_changed.txt; DEF days_of_history_accessed = ’31’; DEF captured_at_least_x_times = ‘1’; DEF captured_at_least_x_days_apart = ‘1’; DEF med_elap_microsecs_threshold = ‘1e4’; DEF min_slope_threshold = ‘0.1’; DEF max_num_rows = ’20’; SET lin 500 ver…
Read MoreSELECT DECODE ( CONCURRENT_QUEUE_NAME, ‘FNDICM’, ‘Internal Manager’, ‘FNDCRM’, ‘Conflict Resolution Manager’, ‘AMSDMIN’, ‘Marketing Data Mining Manager’, ‘C_AQCT_SVC’, ‘C AQCART Service’, ‘FFTM’, ‘FastFormula Transaction Manager’, ‘FNDCPOPP’, ‘Output Post Processor’, ‘FNDSCH’, ‘Scheduler/Prereleaser…
Read More