Category: oracle dba

When Archiving is necessary in Oracle Database

When Archiving is necessary in Oracle Database

January 29, 2019 | By | Add a Comment

For enabling archivelog in Oracle database, we need to consider the primary goal of end users and business requirement. The advantages of archiving generally make it necessary for almost any environment. However, in certain environments, it becomes more of a source of overhead than a facility. It’s always necessary to evaluate the amount of data […]

Read More

Oracle Data Mining – An Introduction

Oracle Data Mining – An Introduction

September 25, 2012 | By | Add a Comment

What is Oracle Data Mining? “A short and solid introduction of data mining concept in Oracle” Oracle Data Mining is one of the most impressive features of the new Oracle Database system. It has been designed with the purpose of discovering new functionality within the data on the system and thus provides new and unique […]

Read More

How to Detect Block Corruption in Oracle?

How to Detect Block Corruption in Oracle?

April 12, 2012 | By | Add a Comment

Block Corruption in Oracle Analysis and Investigation of Corrupt Block in Oracle Database Oracle has four methods for detecting corruption. The analyze commend with the validate structure option can be used to verify the structure of a table, index, or cluster, and to confirm that a table and its indexes are in sync. The external […]

Read More

How to become Oracle expert?

How to become Oracle expert?

February 22, 2012 | By | Add a Comment

Developing experience in databases control area is very hard and challenging. But after becoming expert oracle dba you would produce more definitely. How to become Oracle DBA and how to become an expert Oracle dba?. Here are you can find some main suggestions and comprehension providing for improving your capabilities for making yourself as Oracle […]

Read More

ORA-00600 Errors and Database DBA

ORA-00600 Errors and Database DBA

January 31, 2012 | By | Add a Comment

Hi Friends, ORA-00600 is always annoying Oracle DBA. Of course, it does. Because always it has different symptoms with different version of Oracle. Some time it occurs due to Oracle bug and some time it occurs due to database corruption. It doesn’t have same reason, cause or resolution for different version of Oracle databases. ORA-00600 […]

Read More

Background Processing in Unix

Background Processing in Unix

January 21, 2012 | By | 1 Comment

A mechanism used to run a program in the background, without input from a terminal or from the user. Also called detached processing. To start a background process, end the command line with the ampersand (&); you do not have to wait for this background processing. Both the Bourne shell and the C shell slow […]

Read More