Category: oracle 11g

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

Sub Query limitation in Oracle

Sub Query limitation in Oracle

October 26, 2011 | By | 1 Comment

Hi Friend, Do you know there is a limitation of sub-query in Oracle? If you don’t know then keep in mind following limitation. There is a limitation of Oracle for Subqueries. You can use unlimited sub-queries in FROM clause of main query. You can use maximum 255 sub-queries in WHERE clause of Oracle. This limitation […]

Read More

How to tune disk IO

How to tune disk IO

October 16, 2011 | By | Add a Comment

Hi Friends, How to decrease disk I/O contention and performance bottleneck of Oracle server. Make perfect action plan for reducing disk I/O of oracle server. Here you can find out some tips and techniques. There are lots of tips available in various articles and books. Proper techniques of decrease disk I/O contention and how to […]

Read More