sqlplus "/as sysdba"
prompt The following should return zero rows
select count(*) from v$recover_file;
select count(*) from v$recovery_log;
select count(*) from v$recovery_status;
select count(*) from v$recovery_file_status;
select name,status from v$datafile where (name like '%MISS%' or status not in ('ONLINE', 'SYSTEM'))
select count(*) from v$backup where status != 'NOT ACTIVE' ;
col checkpoint_change# format 999999999999999
prompt The following should return one distinct number
Select distinct checkpoint_change# from v$datafile ;
select distinct to_char(CHECKPOINT_TIME,'DD-MON-YYYY HH24:MI:SS') from v$datafile_header;
prompt This should return "0" and "8192" as output
select distinct fhsta from x$kcvfh;
Integrate Oracle ADF with Oracle E-Business Suite 12.2 ASCP Instance for SPWA - Supply Planning Work Area What is Oracle ADF? Orac...
R12.2. Services Start and Stop Procedure All components - Application (Middle Tier) START $INST_TOP/admin/scripts adstrtal.s...
Enabling TLS in Oracle Apps R12.2 Here we would be looking at the detailed steps for Enabling TLS in Oracle Apps R12.2 Introduction: ...
Apps password change routine in Release 12.2 E-Business Suite changed a little bit. We have now extra options to change password, as well ...