Expert Oracle DBA Blog
Technology - Database news, help and Support
|
February 17th, 2020 :11:16 AM
|
|
|
Oracle Databse 18c comes with some cool new features for DBAs. during this article I’ll list my preferred ones. Just one note: i feel the name “Autonomous Database” is sort of misleading, because it means a number of the new features might be wont to configure your database as “autonomous” where previous versions required some […]
|
|
January 29th, 2020 :09:06 AM
|
|
|
No matter how much I stress it, I cannot overemphasize the importance of this tip. In fact, it is not even tip; it is well documented in Oracle RAC manuals. However, if you are using RAC, chances are that you have not read the Oracle RAC documentation. The non-RAC documentation covers this point in a […]
|
|
March 21st, 2019 :02:59 AM
|
|
|
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 […]
|
|
March 20th, 2019 :12:31 AM
|
|
|
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 […]
|
|
January 30th, 2019 :12:29 PM
|
|
|
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 […]
|
|
January 28th, 2019 :11:34 PM
|
|
|
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 […]
|
|
January 24th, 2019 :11:00 AM
|
|
|
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. […]
|
|
January 21st, 2019 :01:37 AM
|
|
|
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 […]
|
|
January 10th, 2019 :09:34 AM
|
|
|
Article explains characteristics of VPN and definition of Virtual Private Network configuration. From a user perspective, each user is on the internal network. Each has access to all the resources available to someone who is physically connected to the local LAN. The speed or bandwidth is probably the only noticeable difference in a true VPN […]
|
|
January 10th, 2019 :09:06 AM
|
|
|
Constraints are rules that you establish to restrict the values that can be placed in your columns. In basic SQL, constraints are contained in the definitions of base tables and are of two kinds: column constraints and table constraints. The former is part of a column definition and check their rules whenever a statement attempts […]
|
-->
