Friday, 24 July 2015

›
Active Session History (ASH) Analytics in Oracle Enterprise Manager Cloud Control 12c The Active Session History (ASH) was introduced in ...

›
Emergency Monitoring in Oracle Enterprise Manager Cloud Control 12c The Emergency Monitoring feature of Enterprise Manager Cloud Control 12...
Thursday, 23 July 2015

›
Interesting thing : FLASHEARTH : How EARTH looks at night by NASA? http://www.flashearth.com/  
Thursday, 16 July 2015

›
A Brief presentation on Oracle SQL Tuning for those who love Performance troubleshooting in Oracle. Link for Youtube: https://www.youtu...

›
A presentation on SQL Tuning : Please download from below link : https://drive.google.com/file/d/0B6DbhsI8ALh-WVNKSWNRd0lrWWM/view?usp=...
Tuesday, 14 July 2015

›
How Oracle Locking Works Myth: Oracle has a Central Locking System A week or so ago I started a new series – 100 Things You Probably did...
Friday, 10 July 2015

›
Configure E-mail For Oracle Enterprise manager DB 11gR2 Regarding to oracle documentation :- The notification system allows you to notify E...

›
Oracle Database Patches Information A number of questions has been asked here and in Oracle Community Forum When/What/Date for Next Databas...

›
Shutdown Immediate Hangs Today we faced Strange issue with Shutdown immediate command on cluster database which is when run shutdown immedi...

›
Configure DBConsole as Active/passive Sometimes Database Configured as Active/Passive ( Cluster ) Which mean one node working/time and rega...

›
New Features in ORAchk 12.1.0.2.3 The new ORAchk release 12.1.0.2.3 is now available to download from http://support.oracle.com Is your da...

›
Enterprise Manager : Performance Across Enterprise Databases The below link is very to understand the performance under #EM12c Provided by ...

›
Configure RMAN Backup On Windows : Database is supported on windows and some people using Windows As Production and RMAN need to be config...

›
LOG_ARCHIVE_DEST and LOG_ARCHIVE_DEST_1 LOG_ARCHIVE_DEST is applicable only if we are running the database in ARCHIVELOG mode. LOG_ARCHIVE_...

›
What are V$Session_Wait VS V$Session_event?    Both of these tables are view In database , we will talk about what is the difference betwee...

›
How to check Session memory For a Oracle User To check the Memory Usage for Each Seesion :     select username,name,value     from v$sessio...

›
Multiple DataFiles and Multiple Tablespaces As Any Database administrator you are managing your database check the size of your tablespac...

›
ORA-01102: cannot mount database in EXCLUSIVE mode Error happened when try open database :     SQL> startup     ORACLE instance started....

›
Register Listener In Database : Listener listens to new connections who is trying to connect to DB server. If the listener goes down, new u...

›
SGA_MAX_SIZE & SGA_TARGET / MEMORY_TARGET & MEMORY_MAX_TARGET   In this article we will discuss the Difference between these parame...

›
Dealing With Oracle Traces : This article using Oracle Database 11g. How Could I change name for Oracle Trace : alter session set tracefile...

›
How To Change Listener Default Name? Step One : ps -ef | grep tns     oracle    4214     1  0 22:51 ?        00:00:00 /u01/app/oracle/produ...

›
WARNING: Subscription for node down event still pending This is something interesting that I found on one of the searches. Warning Appear l...

›
Convert BLOB to CLOB? How? We took this procedure from OTN forum  to convert BLOB to CLOB     CREATE OR REPLACE FUNCTION blob_to_clob (blo...

›
What does Oracle Version Digit Mean? Have you ever though about this? The first digit is the most general identifier. It represents a maj...