Wednesday, May 9, 2012

DB Queries

General
========
sele¢t to-¢Har(sffisdate, 'DD mON, YYYY HH24:MI:SS') From DUAL
select HOME_URL from icx_parameters;
select release_name from fnd_product_groups;
select nls_language,language_code,installed_flag from apps.fnd_languages where installed_flag in ('I','B');        
select NODE_NAME,SUPPORT_CP,SUPPORT_FORMS,SUPPORT_WEB,SUPPORT_ADMIN,STATUS from apps.fnd_nodes;
select name,open_mode,created,user from v$database;
select count(*) from dba_objects where status='INVALID';
select 'alter '||object_type|| ' ' || owner ||'.'||object_name || ' compile;' from dba_objects where status='INVALID';
select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;
select * FROM v$active_instances;
select DBID,NAME from gv$database;
Select text from dba_errors where name =’' and owner =’’;
Select referenced_owner, referenced_name,referenced_type from dba_dependencies where name=’’ and type =‘’ and owner =’’;
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
select to_char(current_timestamp,'MM/DD/YYYY HH24:MI:SS TZD'),to_char(systimestamp, 'MM/DD/YYYY HH24:MI:SS TZD') from dual;

Alter and Compile
==================
@?/rdbms/admin/utlrp

alter package FUN_VENDOR_PVT_PKG COMPILE SPECIFICATION;
alter package FUN_VENDOR_PVT_PKG compile body;
alter procedure compile;
alter view view_name compile;
alter materialized view view_name compile;

Alter session set events ‘10046 trace name context forever,level 12’;

No comments:

Post a Comment