SELECT statement in combination of ORDER BY or GROUP BY clause performs SORT operation which we all accept from the concepts of oracle architecture. Sort area in MEMORY is one of the areas of PGA in dedicated server architecture or will be part of SGA in shared server architecture. We all believe that sort in […]
After gaining theoretical knowledge from the Oracle documents or from Oracle university training every DBA will be under presumption that only DML operations in the database generates REDO segments. But practically it is not completely true. On few occasions you can identify that SELECT statements generates REDO segments in the instance. Next question you might […]
Understanding SCAN listener functionality has become tough to Oracle DBA’s because of multi layered listeners introduced in Oracle 11gR2 RAC. I have met an Oracle DBA with almost 4 years of experience and working actively on RAC setup for 1 year but lack of knowledge on how SCAN listener works. People often get confused as […]
It was very interesting when I have received an activity to ADD a SCAN listener to the existing RAC 11gR2 setup. As an Oracle DBA each one of us might see such activity in the projects with RAC setup. It is not quite very easy to add a SCAN listener when your environment doesn’t use […]
