I had my database streams capture process stuck at WAITING FOR DICTIONARY REDO : FIRST SCN 52170068520 status when re-starting the capture…
I’ve come across many posts in the OTN forums wherein the OP faces sync issues between the Physical Standby and…
Downloadable free tool from MOS for doing a Security assessment for Oracle Database (compatible with 10.2,11.2,12) https://support.oracle.com/epmos/faces/DocumentDisplay?id=2138254.1
The Unified Auditing in Oracle 12c can Grow the SYSAUX table to a large size. In our case it grew…
[sourcecode language=”sql”] run { allocate channel sbt1 type sbt parms ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; allocate channel sbt2 type sbt parms ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; CONFIGURE DEFAULT…
The Below Script will generate output if percentage of tablespace space left free is less tan 20%. You can easily…
First Install UTL_MAIL ### To install UTL_MAIL: [code language=”sql”] sqlplus sys/**** @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb [/code] ### Create a Reporting User ###…
The script below can be used to check the Disk Group Space Free and also Check Directory sizes for each…
Setup for the Environment ——————- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 12.1.0.2 DB Home…