Author Archive: orageekdba

rss feed

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 DBaaS DBA Role in Oracle Cloud?

What is DBaaS DBA Role in Oracle Cloud?

March 20, 2019 | By | Add a Comment

The role of Oracle DBAs has been constantly evolving past the 1990s. For a long duration of time, around the 70s, 80s, and 90s, the deal has been quite different, but not easy for sure. That has grown to become substantially different today, but not easy, and maybe something totally new in the next two […]

Read More

A Simple Shell Script Example

A Simple Shell Script Example

January 30, 2019 | By | Add a Comment

A Simple Shell Script Example Combining various command options can lead to hideously complex commands. If you are loath to type such long-winded commands on a regular basis, Unix and Linux offer the shell script option, which merits a brief detour. Here is you can find out the simple practical approach of shell script. You […]

Read More

When Archiving is necessary in Oracle Database

When Archiving is necessary in Oracle Database

January 29, 2019 | By | Add a Comment

For enabling archivelog in Oracle database, we need to consider the primary goal of end users and business requirement. The advantages of archiving generally make it necessary for almost any environment. However, in certain environments, it becomes more of a source of overhead than a facility. It’s always necessary to evaluate the amount of data […]

Read More

Oracle Performance Tuning -Application Optimizing is more important

Oracle Performance Tuning -Application Optimizing is more important

January 24, 2019 | By | Add a Comment

Application Optimizing is more important in Oracle Performance Tuning Applications often are an end user’s only access to the database. Only through an application can the end user peek into the database. In other words, the application offers database visibility to the end user. If the applications are up and running, the database is available. […]

Read More

How to be expert in Oracle Performance Tuning?

How to be expert in Oracle Performance Tuning?

January 21, 2019 | By | Add a Comment

For being a master in Oracle server tuning, it is not sufficient to get Oracle DBA knowledge. But some other field knowledge is required. Like operating system knowledge, storage structure knowledge, some networking and application knowledge. It means you need almost all domain knowledge which is directly impacted to Oracle database. Operating system knowledge is […]

Read More