Category: oracle 9i dba

What is Workspace in Oracle?

What is Workspace in Oracle?

May 27, 2014 | By | Add a Comment

Oracle introduced a new idea that narrates to concurrency. The workspace is a transactionally constant view of all the tables in a database that have been permitted for workspace versioning. There is a PL/SQL package called DBMS_WM used for enabling and disabling workspace versioning for tables. The changes that are made in a workspace are […]

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

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

Which is best Database

Which is best Database

November 6, 2011 | By | Add a Comment

Which database is best for your business -case study

Read More

Parallel Operation in Oracle Server- Does it improve Performance?

Parallel Operation in Oracle Server- Does it improve Performance?

February 12, 2011 | By | Add a Comment

Parallel Operation in Oracle Server- Does it improve Performance or not pros and cons of parallel execution of Oracle.

Read More

What is the best online Oracle training?

What is the best online Oracle training?

January 3, 2011 | By | 1 Comment

5 points to be considerable in online oracle training course searching

Read More