In this article we will explain how to change the default MySQL data directory to a different mount point or location on a CentOS/RHEL...
Hidden SQL- Why v$sql is not displaying sql_fulltext in Oracle
Recently i came across a situation where i was not able to see the SQL text for my sql_id. Developer and application guys were struggling to fix the backlog piling into the system during data loading. They had configured a piece of code called dbwritter - not a database dbwritter. This process will pick the...
How insert statement works internally in oracle
In this post, we will see the flow and sequence of steps which oracle follow internally for the execution of insert statement. So below are...
How update statement works internally in oracle
In this post, we will see the flow and sequence of steps which oracle follow internally for the execution of update statement.
How...
Network Wait: SQL*Net more data from client in awr report
In one of the sites, I came across a performance issue where data loading task was taking more than usual. After analysing the AWR report,...
How select statement works internally in oracle
In this post we will discuss about the order or flow of execution of select statement in oracle.
To write a select query against an oracle...
How to Enable/Disable ARCHIVELOG Mode in Oracle 11g/12c
When you run the database in NOARCHIVELOG mode, you disable the archiving of the redo log. If you want to take the backup of the database using RMAN then your database must be in ARCHIVELOG mode.
A database backup, together with online and archived redo log files, guarantees that you can recover all committed...
Streams AQ: enqueue blocked on low memory Wait Event in Oracle
In this post, we will discuss about the wait event "Streams AQ: enqueue blocked on low memory" which was captured in the oracle AWR report.
In...
MySQL: Can't start server: Bind on TCP/IP port: Address already in use resolved
In this article we will discuss the about the issues we faced after changing mysql data directory.
For one of the environment, there was a requirement to install mysql 5.6 server on CentOS Linux and after installation we had to change the default data directory to the new location.
Everything was fine but...
[RESOLVED]: ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 50556, now running 50640
In this article, we will discuss about the issue which we faced after mysql database server installation.
Recently there was a reqirement to install mysql server and to create few mysql databases. As per requirement, we created the databases but during user creation we faced the below error.
ERROR 1558 (HY000):...
Subscribe to:
Posts (Atom)