Quick Reference for Oracle Apps DBA

Hiya Buddies,

Hope you all are rocking either tech or Nontech skilles… If not please visits here we would like to share the skills which may useful either in tech or nontech lifes…

Here we would like to share the very important technical stuff which is useful and helpful in daily tasks.

These will be useful for Quick accees and use it. To make some query and tips handy we thought to share here…

We will keep update whenever we feel that this is important and useful for others here and also it should be handy then would like to share and update here…

How to take CM list details front-end

1. Go to front-end --> Administrator Concurrent manager --> File (at top menu) --> Export.

How to check Archive log Gap in Standby Database:

SQL> select * from v$archive_gap;

Where the log Apply stuck:

SQL> select sequence#,process,status from v$managed_standby;

How to take sql output file in xml format:

set feed off markup html on spool on

SET PAGESIZE 50000

SPOOL file_name.xls

select * from fnd_profile_options ;

SPOOL OFF

ASM alert log file Location:

oracle@ora-data:/sku/app/oracle/diag/asm/+asm/+ASM1/trace$ pwd

/sku/app/oracle/diag/asm/+asm/+ASM1/trace

oracle@ora-data:/sku/app/oracle/diag/asm/+asm/+ASM1/trace$ tail -100f alert_+ASM1.log

How to check Database size:

select sum(bytes)/1024/1024 size_in_mb from dba_data_files;

select sum(bytes)/1024/1024 size_in_mb from dba_segments;

To be continued...

Some more useful links:

How to Study and Prepare for Exams

How to Enable or Disable Archive log mode in oracledatabase 11g

How to export query output to Excel in Oracle SQLDeveloper

How to check notepad++ backup files

Regards,

TechOrNontech Team