Category: oracle 10g

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

Transparent Application Failover-Oracle RAC

Transparent Application Failover-Oracle RAC

November 29, 2012 | By | Add a Comment

Transparent Application Failover TAF in Oracle RAC Transparent Application Failover TAF is an automatic database session re-establishment or reconnection characteristic built into Oracle Call Interface (OCI) in Oracle Network. It is principally aimed for Real Application Cluster RAC environments to re-establish database sessions in case of cluster node failure or instance breakdown, but the utility […]

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

Oracle Tuning using System Load Performance

Oracle Tuning using System Load Performance

January 30, 2012 | By | 1 Comment

System Load is the key feature to observe Oracle Database Performance: System load levels are determined by all of the processes sharing the kernel run queue. If there are not enough CPU cycles to handle the workload of all such processes efficiently, chance are that the processes have to get in line, waiting for the […]

Read More

Oracle 10g New Features

Oracle 10g New Features

November 30, 2011 | By | Add a Comment

Top 10 Oracle 10g new features

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