Blog Posts on scripts




Percent:
 
Distinct:
 


Query to Check Inactive Sessions by Jimbart's Oracle DBA Blog on Feb 14, 2013  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...



Script to Check Maximum Processes by Jimbart's Oracle DBA Blog on Feb 5, 2013  Instead of querying the v$parameter or executing the show parameter command then querying the v$process dynamic view. This query will return the maximum and current utilization of processes on...



Changing Archivelog Destination of the Primary Database by Jimbart's Oracle DBA Blog on Aug 28, 2012  Usually it is generally easy to change the archivelog destination of the primary database especially when the current archivelog destination system is almost full. However, when Oracle Dataguard is...



Check Standby Database Archive Log Gap by Jimbart's Oracle DBA Blog on Aug 28, 2012  How to monitor archive log shipping in Oracle databases using Oracle Dataguard technology for standby databases. Monitor Archivelog Gap: SELECT ' DGSYNCH' as column_title, max(p.sequence#) primary_current_log, max(s.sequence#) secondary_curren...



“Jeep” by Gen Gonzales by Gen Gonzales on Aug 15, 2012The names that I used in this story are not based on real people.



Query to Detect Sessions Using up a Lot of Database Resources by Jimbart's Oracle DBA Blog on Aug 1, 2012A common issue among databases are sessions/users that overuse database resources which causes database performance degredation. This can be averted through the use of Oracle’s Resource Manager but it is...



Query to check blocking sessions by Jimbart's Oracle DBA Blog on May 9, 2012  Here’s a query I use to check for blocking sessions on the database. A deadlock is composed of 2 sessions blocking each other (2-way blocks) and a single blocking...



DDoS attackers turning to simple ‘booter’ scripts by dralnuX on May 4, 2012Internet criminals are sidestepping the need to launch DDoS attack from large networks of malware-compromised bot PCs by using simpler server ‘booter shells’, mitigation firm Prolexic has warned. ‘Booter shells’ or plain ̵...



Query to Generate Gather Statistics on Tables by Jimbart's Oracle DBA Blog on Apr 28, 2012  Query to automatically generate GATHER table statistics for all tables that have stale statistics. DBMS_STATS is the preferred method of gathering table statistics vs the deprecated ANALYZE table command...



ORA-14452: attempt to create, alter or drop an index on temporary table already in use by Jimbart's Oracle DBA Blog on Apr 19, 2012  This is caused by another session holding a lock on the object in question. As per oerr error facility: oerr ora 14452 14452, 00000, “attempt to create, alter or...