dbms imp statements

select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from dual;

Explain PLAN FOR SELECT * from dummy;

ANALYZE TABLE  COMPUTE STATISTICS;

/*Query to find the Performance of Tables*/
SELECT timestamp,operation,object_owner,object_name,object_type,optimizer,id,parent_id,position,cost,bytes / 1048576 mb,cpu_cost,io_cost 
FROM v$sql_plan 
ORDER BY timestamp DESC;

/*Query to find the Performance of DB Objects*/
Select OWNER, TYPE, NAME, EXECUTIONS, SHARABLE_MEM, KEPT
from v$db_object_cache
where type in ('TRIGGER','PROCEDURE','PACKAGE','PACKAGE BODY')
and name like 'AASC%'
order by Name,Type;

select * from PLAN_TABLE order by TIMESTAMP desc;

/*Query to find the schedulers*/
SELECT fcr.request_id,
DECODE(fcpt.user_concurrent_program_name,
'Report Set',
'Report Set:' || fcr.description,
fcpt.user_concurrent_program_name) CONC_PROG_NAME,
argument_text PARAMETERS,
NVL2(fcr.resubmit_interval,
'PERIODICALLY',
NVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')) PROG_SCHEDULE_TYPE,
DECODE(NVL2(fcr.resubmit_interval,
'PERIODICALLY',
NVL2(fcr.release_class_id, 'ON SPECIFIC DAYS', 'ONCE')),
'PERIODICALLY',
'EVERY ' || fcr.resubmit_interval || ' ' ||
fcr.resubmit_interval_unit_code || ' FROM ' ||
fcr.resubmit_interval_type_code || ' OF PREV RUN',
'ONCE',
'AT :' ||
TO_CHAR(fcr.requested_start_date, 'DD-MON-RR HH24:MI'),
'EVERY: ' || fcrc.class_info) PROG_SCHEDULE,
fu.user_name USER_NAME,
requested_start_date START_DATE
FROM apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_concurrent_requests fcr,
apps.fnd_user fu,
apps.fnd_conc_release_classes fcrc
WHERE fcpt.application_id = fcr.program_application_id
AND fcpt.concurrent_program_id = fcr.concurrent_program_id
AND fcr.requested_by = fu.user_id
AND fcr.phase_code = 'P'
AND fcr.requested_start_date > SYSDATE
AND fcpt.LANGUAGE = 'US'
AND fcrc.release_class_id(+) = fcr.release_class_id
AND fcrc.application_id(+) = fcr.release_class_app_id;
	
CREATE PUBLIC DATABASE LINK  CONNECT TO   IDENTIFIED BY  USING 'SCQAR12';

CREATE PUBLIC DATABASE LINK  CONNECT TO apps  IDENTIFIED BY  USING 'SCDR12';
    
CREATE INDEX INDEX_NAME ON TABLE_NAME(COLUMN_NAME);

select release_name from apps.fnd_product_groups;

http://www.oracleerpappsguide.com/2012/02/performing-pick-release-using-wsh_delivery_pub-api.html

https://www.allerair.com/pages/28-reasons-you-need-an-air-purifier




-- ACL's :
BEGIN
  DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl          => 'local_sx_acl_file.xml', 
    description  => 'Rest API Test',
    principal    => 'APPS',
    is_grant     => TRUE, 
    privilege    => 'connect',
    start_date   => SYSTIMESTAMP,
    end_date     => NULL);
end;
/

begin
  DBMS_NETWORK_ACL_ADMIN.assign_acl (
    acl         => 'local_sx_acl_file.xml',
    host        => '52.3.85.121', 
    lower_port  => 9999,
    upper_port  => NULL);    
end;
/ 

http://genrontech.com/online-important-links/




-- FND_PROFILE values: 
 fnd_profile.value('PROFILEOPTION');
 fnd_profile.value'MFG_ORGANIZATION_ID');
 fnd_profile.value('ORG_ID');
 fnd_profile.value('LOGIN_ID');
 fnd_profile.value('USER_ID');
 fnd_profile.value('USERNAME');
 fnd_profile.value('CONCURRENT_REQUEST_ID');
 fnd_profile.value('GL_SET_OF_BKS_ID');
 fnd_profile.value('SO_ORGANIZATION_ID');
 fnd_profile.value('APPL_SHRT_NAME');
 fnd_profile.value('RESP_NAME');
 fnd_profile.value('RESP_ID');
 
 -- FND_GLOBAL values: 
 FND_GLOBAL.USER_ID;
 FND_GLOBAL.APPS_INTIALIZE;
 FND_GLOBAL.LOGIN_ID;
 FND_GLOBAL.CONC_LOGIN_ID;
 FND_GLOBAL.PROG_APPL_ID;
 FND_GLOBAL.CONC_PROGRAM_ID;
 FND_GLOBAL.CONC_REQUEST_ID;
 
 -- Examples to initialize the application environment:
 v_user_id PLS_INTEGER := fnd_global.user_id;
 v_login_id PLS_INTEGER := fnd_global.login_id;
 v_conc_req_id PLS_INTEGER := fnd_global.conc_request_id;
 v_org_id PLS_INTEGER := fnd_profile.value('ORG_ID');
 v_sob_id PLS_INTEGER := fnd_profile.value('GL_SET_OF_BKS_ID');
 v_resp_appl_id := fnd_global.resp_appl_id;
 v_resp_id := fnd_global.resp_id;
 v_user_id := fnd_global.user_id;
 FND_GLOBAL.APPS_INITIALIZE(v_user_id,v_resp_id, v_resp_appl_id);