Category: oracle

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

What is SQL and what are SQL versions

What is SQL and what are SQL versions

December 4, 2010 | By | Add a Comment

Hi Friends, Today we are discussing different topic called what is SQL and what are the SQL versions. If this questions is being asked to any DBA or Developer then can anybody will be able to answer? Due to this reason, We are publishing the article to explain everything of SQL. From the start to […]

Read More

How can perform Expdp with consistent=y

How can perform Expdp with consistent=y

October 22, 2010 | By | Add a Comment

Hi Friends, After introducing DATAPUMP, there are lot of confusion occurring. One of those confusion is how to perform export using EXPDP (datapump) like exp consistent=y. Because in export when we are using consistent=y, there would be very chance to get ORA-01555 snapshot too old error in live database. In 24*7 running database active DML […]

Read More

Oracle 8i Hidden Parameters

Oracle 8i Hidden Parameters

November 9, 2009 | By | Add a Comment

Hello friends, As per our promise we are providing Oracle tips and technical papers for about some internals of Oracle database.It is very important for every advance Oracle DBA. http://www.dbametrix.com/resource_database.html Day by day in new version of Oracle we found hidden parameters are being increased.Oracle 8i is having 555 hidden parameters. Hidden parameters called as […]

Read More

New Oracle DBA forums

New Oracle DBA forums

October 21, 2009 | By | 2 Comments

Hi friends, Great news from Dbametrix that, new Oracle DBA Forum has been initiated as follows. It is totally FREE. http://oracledba.forumotion.net/ For sharing knowledge,news,tips,scripts,problems for Oracle DBA you can take benefit of same Oracle DBA forums. http://oracledba.forumotion.net/ This Oracle DBA forums is helping you to download OCP exam preparation study materials, Searching for Oracle DBA […]

Read More

News from Dbametrix

News from Dbametrix

October 10, 2009 | By | Add a Comment

http://www.dbametrix.com/service.html

Read More