Every user session on Oracle database will be able to access default table PLAN_TABLE to collect execution plan of a query from EXPLAIN PLAN command. But, how is this table available to all the users in the database and gets empty once you disconnect? Is this table available and created for every user logging into […]
On Oracle RAC environment Load Balancing is something which is critical for distribution of connections between the servers we have. Load Balancing Advisory (LBA) is one of the key components for SCAN listener to decide the best instance for the new incoming connection request. I was just wondering if we can check if Load Balancing […]
We must have known already that block sizes of non-system tablespaces can be controlled and altered, but did you ever think of block sizes of Control files and Redo log files in the database? How to check their block sizes if they have so, can we alter them when required? Well, it is really very […]
Choosing the best suitable storage disk for your Oracle database is very important when you architect the environment for better performance. Not just considering database files (Data files, Control files, Redo logs, Archive logs etc…) it is also vital to look at the type of application and the data flow in and out of the […]
Installing Oracle Database software is one of our regular activities as DBA. There might be supporting notes in each and every project we support, to complete it quicker and more efficiently. One of the pre-requisites we implement is to set up appropriate Kernel parameters at the operating system level on UNIX platforms. But, it would […]
Flashback feature in Oracle database is well known to roll back the table to a specific timestamp (depends on undo retention) or to restore dropped table and many more. We must have used this flashback feature so far on application schema objects and found working without any issues. As an Oracle DBA did you configure […]
We must have been involved in only technical activities and issues on Oracle database every day, but most of the DBA’s must have a limited or no knowledge on how Oracle charges customers with their license models. Most of us might know that Oracle database is free for learning, testing and for any non-profit applications […]
Your handy scripts are as important as your Oracle DBA profile. We do have lot of scripts, documents, white papers and so on for our reference which are very vital throughout the career. The first source to find answers for any issue or an activity in the environment is your catalog directory where you must […]
Oracle DBA role is perceived to very hectic and demanding in terms of both energy and time. It is well understood that Oracle DBA’s will be mostly working in rotational shifts, overtime and few times are deprived of good sleep. For a moment, let us look at some other profiles/roles which demand similar working styles. […]
Most of us (Oracle DBAs) query GV$ views in RAC environment to gather information from multiple or all the nodes in the cluster. We call them as Global Dynamic Performance Views. Unlike V$ views, these will collate data from all the instances in RAC. We are going to look at this process in detail with […]
