HOW TO RESIZE INNODB LOGS?
If for any reason you need to change the size of InnoDB log files (also known as transaction logs), but not sure how to do it, this post will guRead More…
If for any reason you need to change the size of InnoDB log files (also known as transaction logs), but not sure how to do it, this post will guRead More…
Step # 1: Stop the MySQL server process. [[email protected] ~]# /etc/init.d/mysqld stopStopping mysqld:  Read More…
The Oracle 12c Scheduler example here creates a simple job that runs a stored Programming Language/Structured Query Language (PL/SQL) procedure. The Read More…
BEGIN FOR R IN (SELECT owner, table_name FROM all_tables WHERE owner=’TheOwner’) LOOP EXECUTE IMMEDIATE ‘grant select on ‘||R.owner||’.’||R.Read More…
When you monitor a Oracle Standard Edition, you did not have a Tuning or Diagnostic Pack. This Feature must be disabled because they are not allowed Read More…
I was assigned to collect performance data on an unfamiliar database. While I ran AWR report by executing @?/rdbms/admin/awrrpt.sql under SRead More…
In MySQL it is a very beautiful way to find the server’s over all current status or even we can generates a HTML code to get a report like Oracle ARead More…
The following query can be used to determine the memory usage rates in Oracle databases. If there is an increase in the memory values from timeRead More…
Patching is one of the most common task performed by DBA’s in day-to-day life . Here , we will discuss about the various types of patches which are pRead More…
STEP 1:Check the operating system bit version (32 bit or 64 bit). [[email protected] ~]$ uname -a Linux host11.intra.searshc.com 2.6.18-308.1.1.el5xRead More…