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

How to resolve the ORA-00257 error in Oracle database

ORA-00257 is one of the commonest error in Oracle DBA life. He/She often has to deal with it.Database almost got frozen because of it and all transaction get stopped .Let us see how to deal with ORA-00257 error Error Message   ORA-00257: archiver error. Connect internal only, until freed. As per The oerr ORA-00257 error means ORA-00257: archiver error. Connect internal only, until freed. Cause: … Continue reading How to resolve the ORA-00257 error in Oracle database »

How to resolve ORA-29913 with external tables

ORA-29913 is one of the common error when working with external tables in Oracle database. We would be looking at various ways the error can be produced and what can be done to resolve the error External File not found or permission incorrect SQL> select * from Scott.example_external_table; select * from example_external_table * ERROR at line 1: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data … Continue reading How to resolve ORA-29913 with external tables »

Top-N Queries and Pagination

Top-N Queries  and Pagination is common in Web-based applications. The user inputs a set of criteria, which runs a query and then lets the user click the Previous and Next buttons to page through the result set. To achieve this paging functionality, the application needs to be able to get a certain set of rows from the Database query. Lets take a look at the … Continue reading Top-N Queries and Pagination »

Top 10 Useful Queries for Flashback Database

Introduction to Flashback Database .It is faster than traditional point-in-time recovery. The traditional recovery method uses backups and redo log files; Flashback Database uses a new type of log file called the Flashback Database log. The Oracle database server periodically logs before images of data blocks in the Flashback Database logs. The data block images are used to quickly back out changes to the database during … Continue reading Top 10 Useful Queries for Flashback Database »

Oracle Flex Cluster 12c

With 12c, Oracle has introduced Oracle Flex cluster.Oracle Flex cluster 12c is a new Oracle Clusterware based High Availability clustering topology It Utilizes two types of cluster nodes: Hub nodes Traditional nodes, tightly coupled via network and storage, used for running IO intensive workload Leaf nodes Leaf Nodes A new type of node that runs a lighter weight stack Maintain their own failure and heartbeat … Continue reading Oracle Flex Cluster 12c »

Online move of active datafile in 12c

Last updated on October 11th, 2016 at 06:24 pmFor rename and  relocation of datafile in pre 12c release, we need to put the tablespace in offline mode  then do the movement and then bring it online again. So  it was a offline task with number of task to perform With 12c R1  , a data file movement  no longer requires a number of steps i.e. put … Continue reading Online move of active datafile in 12c »

5 Simple (But Important) Things To Remember About Oracle Database 12c views ,parameters and packages

Last updated on August 23rd, 2016 at 05:09 am5 Simple (But Important) Things To Remember About Oracle Database 12c views ,parameters and packages Multitenant Database Oracle is doing every thing to jump into the cloud bandwagon. With 12C, Oracle is trying to address the problem of Multitenancy through this feature. There is a radical change and a major change in the core database architecture through … Continue reading 5 Simple (But Important) Things To Remember About Oracle Database 12c views ,parameters and packages »

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 »