I am exploring another database storage solution “MySQL” to understand practical applications of using MySQL in our environment.
This is one of the many articles that I will be writing on MySQL. This article gives you brief steps to installing MySQL on Linux.
Nothing different than what is provided in MySQL documentation except that this is less elaborate with only required steps compared to MySQL documentation.
This is how you can do the installation:-
Why noSQL ?
From past few years (after 2009) we are seeing high trend towards noSQL databases. Many big enterprises are exploring option for moving services to noSQL databases and many already did.
Its not that existing Oracle databases cannot support the system. We have many rich features and products from Oracle which can be made to work together to support huge internet applications. But there are many vantage points to consider when we are designing (more...)
What it used to be
After Oracle 9.2, there has been a significant changes in redo behavior. Before 10g, Oracle used to have a single log buffer for writing redo information which eventually gets written to online redo logs in round robin fashion. Of course if your database is (more...)
One of the parameter we configure in physical standby setup is about how much amount of time LGWR on primary should wait for physical standby to respond.
When changes happens on primary side, those redo changes are shipped on physical standby database. If physical standby database is down or if (more...)
Recently I ended up screwing up my Apex application. I was trying to enable SSL (making URL https) for security reason and somehow the configuration did not work on production.
At this stage I was trying to get back my APEX application. Unfortunately nothing seems to be working.
So I (more...)
I have seen many times DBAs are getting confused with Static registration and dynamic registration of services/instance with listener.
As far back I remember, dynamic registration of services was introduced in Oracle 9i.
In this article, I am going to cover everything about static and dynamic service/instance registration with listener (more...)
In my previous posts we have seen fixing plans by applying baselines and profiles.
For profiles we saw in details how to generate the same using SQL hints.
This article is about another feature of Oracle 11.2, called SQL Patch.
I am not sure if this is supported by Oracle, but in days to come they will make this official.
This is a kind of silver bullet for doing minor changes in the plan which is difficult to get it done using baselines and profiles.
What is SQL Patch:
A SQL patch is a SQL manageability object that can (more...)
One of the many challenges that we face in production environment is make changes to big tables.
If you consider a case of any OLTP systems, its easy to have tables whose size is beyond 10G.
This again depends on the nature of the database and kind of transactions happening on the table.
So lets consider a case where you have a big table which is also a very hot table having very high number of transactions / sec and something that continues 24X7.
Its difficult to take downtime on such tables and making DDL changes to such tables (more...)
We have seen Materialized view Concepts – Discussion Series 1 and Materialized view Concepts – Discussion Series 2.
This is the third article about Materialized views.
In this article we are going to discuss “How fast refresh works ?”
How fast refresh works ?
As we know in case of fast refresh only the changes that happened on master site (or master table) will be applied to MView on target site.
So the changes that happens on master table will be stored in MLOG table created on top of master table.
This is more efficient way than doing complete refresh.
We have seen Discussion Series 1 of materialized view concepts and we know how to create materialized view and also what each clause of Mview creation mean.
In this article we will see all backend tables that can be accessed to check the details of materialized view.
We will begin with identifying materialized view
DBA_SNAPSHOTS (On MView site)
Most important table for checking MView info is DBA_SNAPSHOTS.
We need to query this table on snapshot site (where MView is created)
SQL>select name, table_name, MASTER, MASTER_LINK, REFRESH_METHOD, UPDATABLE , LAST_REFRESH, STATUS, PREBUILT, REFRESH_MODE from dba_snapshots where name = 'T_REP';