How to Optimize MySQL Tables and Defragment to Recover Space
If your application is performing lot of deletes and updates on MySQL database, then there is a high possibility that your MySQL data files are fragmRead More…
ORA-01031: Insufficient Privileges When Connect As Sysdba
Not able to connect Oracle database, When issue command — > sqlplus “/ as sysdba” [[email protected] ~]$ sqlplus “/ as sysdba”SQL*Read More…
Oracle RAC log files locations
If you are using RAC system (doesnt matter how many nodes you have) You need to know where log files are located. In this post, I share those log Read More…
Drop all tables in Oracle DB (Schema)
Imagine you have a list of tables in your Oracle DB and you want to drop them all using a client like SQLDeveloper. That’s easier said then done, as Read More…
How to Determine If the Oracle Redo Log File Size Is a Problem
Two potential problems are possible that should be addressed when considering whether to increase the size of Oracle log files: batch jobs that donRead More…
Who is connected to my Oracle database?
Would you like to know who is connected to your Oracle database? Is there anybody currently connected? How to check where the connections come from? Read More…
Renaming SYSTEM datafiles of Oracle Database
System tablespace is the most critical tablespace in Oracle database. To rename datafiles related to SYSTEM tablespace , we cannot proceed as we procRead More…
ORA-01555: snapshot too old
The ORA-01555 error is caused by Oracle read consistency mechanism and is usually associated with long running UPDATE SQL and too small UNDO. This isRead More…
How to solve ORA-01031: insufficient privileges when creating a materialized view
At first, I got the following error from the Oracle server when exeuting the “CREATE MATERIALIZED VIEW” script: where tab2.year > to_numbeRead More…
Oracle DB – Monitor with nagios using check oracle health
This tutorial explains how to set-up the check_oracle_health script (credits to Gerhard Lausser) to work on your Nagios environment onRead More…