Category Archives: Oracle Database

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.Many companies has implemented their data in Oracle. Most of them are mission critical. So Oracle database concept need to be very clear to manage these mission critical things. At the same time Oracle database needs to deliver high performance also. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Below section I have tried to present all the important features in Oracle Database management

Top 10 Oracle Database Security Tips for DBA

Last updated on August 23rd, 2016 at 05:11 amCritical data are stored in database and data leaks can jeopardize the organization. So database security is very important. Database Security has always been a concern for a Database Administrator. However, Oracle Database is very much secure, even then there are gaps which has to be filled by DBA to make Oracle Database Secure. Oracle Database Security … Continue reading Top 10 Oracle Database Security Tips for DBA »

Top Oracle Enterprise Manager 13c Features

Last updated on November 5th, 2016 at 07:36 amOracle Enterprise Manager  13c is the latest release of Oracle on enterprise side. This release enable lot of new interesting to ease the administration,migration and monitoring. Top new features are 1. Gold image based agent lifecycle management Enterprise Manager administrators spend a lot time on various agent life cycle operations starting from a fresh installation through upgrade … Continue reading Top Oracle Enterprise Manager 13c Features »

Top Oracle 12c New Features for developers

Last updated on August 27th, 2016 at 07:35 amOracle has released 12c with lot of new fetaures. Here in this article,I would presenting the top Oracle 12c New Features for developers I have categorized the features in the broad category to make it easier to understand and use SELECT IMPROVEMENTS 1) Top-N feature A Top-N query allows us to retrieve the top or bottom N rows … Continue reading Top Oracle 12c New Features for developers »

Step by Step Oracle 12c Database Installation on Linux

Last updated on May 4th, 2017 at 05:28 pmI will be posting the step by step Oracle 12c Database Installation on Linux. First we will performing the binaries installation and then creating the database using dbca Package and OS requirements We can install the Oracle Provided 12c preinstall package to meet the  Package and OS requirement running the below yum command (as root): yum install … Continue reading Step by Step Oracle 12c Database Installation on Linux »

How to turn on the SQL trace, 10046 event in Oracle database and trcsess, tkprof utility

Last updated on August 16th, 2016 at 05:30 pm Tracing is a important part for Oracle database tuning. This will help capture all the problem statement , wait event which are responsible for slow running of the session. Oracle has provided has many quickest ways to trace the local session, other user session   and format the trace to make readable. Let us take some look … Continue reading How to turn on the SQL trace, 10046 event in Oracle database and trcsess, tkprof utility »

How ASM Failure Groups and CSS provides high availability

Last updated on August 27th, 2016 at 04:56 amASM Failure Groups and Redundancy 1)For systems that do not use external redundancy, ASM provides its own internal redundancy mechanism and additional high availability by way of failure groups 2) It is also collection of disk and is considered as subset of disk group. 3)Disk group redundancy can be Normal – It is Two-way mirroring requiring at … Continue reading How ASM Failure Groups and CSS provides high availability »

How to create Oracle view

Last updated on November 29th, 2016 at 10:52 amWhat is Oracle  view? -A view is a representation of data from one or more tables or views. -A view is a named and validated SQL query which is stored in the Oracle data dictionary. –Views do not contain any data – it is just a stored query in the database that can be executed when called. All the data it … Continue reading How to create Oracle view »

ASM : Lesson 3 ASM Diskgroups

ASM DiskgroupsOnce the disks are discovered, a diskgroup can be created that will encapsulate one or more of these disks. It is collection of disks that can managed as logical unit.A diskgroup, which is the highest-level data structure in ASM, is comparable to a LVM’s volume group. The creation of a diskgroup involves the validation of the disks to be added. These disks must have … Continue reading ASM : Lesson 3 ASM Diskgroups »

ASM : Lesson -2 How to prepare the ASM disks

Last updated on August 19th, 2016 at 06:11 pmASM Disks The first task in building the ASM infrastructure is to discover and associate (adding) ASM disks under ASM management. This step is best done with the coordination of Storage and Systems administrators. The Storage administrator will identify a set of disks and create the appropriate LUNs from the storage array and finally present them to … Continue reading ASM : Lesson -2 How to prepare the ASM disks »

How to find session details in Oracle database

Many times DBA need to look at the session details for analysis. The details includes sql_id, stats ,locking ,wait events.Here I am giving few queries on How to find session details in Oracle database   To find session Information col sid format 9999 col pid format 9999 col serial# format 99999 col process format a8 heading “unixPID” col spid format a8 heading “unixPID” col username format … Continue reading How to find session details in Oracle database »

Oracle Wait Events That Everyone Should Know part-II

Last updated on July 28th, 2016 at 05:58 pmThis is part II in series of Oracle Wait Events That Everyone Should Know control file sequential read The process is waiting for blocks to be read from a control file. This happens generally making a backup of the controlfiles sharing information (between instances) from the controlfile reading other blocks from the controlfiles reading the header block … Continue reading Oracle Wait Events That Everyone Should Know part-II »

Oracle ASH(Active Session History) Useful queries

Last updated on August 27th, 2016 at 05:07 amActive Session History (ASH) was introduced in Oracle 10g. It samples the activity of each active database session every second. The data is held in a buffer in memory in the database.The design goal is to keep about an hour (your mileage will vary). If a session is not active it will not be sampled. The in-memory … Continue reading Oracle ASH(Active Session History) Useful queries »