Category: oracle 12c dba

Deprecated Initialization Parameter in Oracle 12c Release 2

Deprecated Initialization Parameter in Oracle 12c Release 2

March 21, 2019 | By | Add a Comment

To understand changes and replacements in parameter settings, review the parameters are following. O7_DICTIONARY_ACCESSIBILITY Initialization Parameter: The formatting parameter O7_DICTIONARY_ACCESSIBILITY controls restrictions on SYSTEM privileges. If the parameter is about to TRUE, then access to things within the SYS schema is allowed. The default setting is fake. This default setting prevents system privileges that permit […]

Read More

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

Oracle Database 12c New Features

Oracle Database 12c New Features

November 24, 2013 | By | Add a Comment

Oracle Database 12c New Features Off course friends, Oracle 12c database has been launched before 2 months back. C stands for cloud computing in Oracle 12c database. Indeed, this new version launched with some new features and fixed with some old known bugs. Every new Oracle release is having some good new features and Oracle […]

Read More