Query to Check Inactive Sessions on Feb 14, 2013 in Scripts What to do when processes reach the maximum? You can cleanup sessions that have been inactive for a long time or increase the processes parameter. select 'alter system disconnect...

Relocating Oracle RAC services on Nov 2, 2012 in Uncategorized During maintenance activities where only one (1) or not all of the database nodes/instances are shutdown, services are automatically relocated by Oracle to the other remaining online database nodes/instances....