Parallel Operation in Oracle Server- Does it improve Performance or not pros and cons of parallel execution of Oracle.
Oracle on Windows and Oracle on Unix/Linux details. Difference between Oracle on Windows,Unix,Linux explanation.
http://www.dbametrix.com/ctxsys-context-index-creation.html
Hi friends, In various critical situations Oracle DBA has to decide to kill existing session or kill the background process of Oracle. Then question is raised that in which type of situation remote dba should need to kill session and process. We are explaining those situations and incidences here. When blocking lock occurs and other […]
SymptomsWhilst using GUI DBCA tool the error code “Exception:TNS-04414: file error” is reported. Cause Some DBCA operations require to read and parse the net admin files, TNSNAMES.ORA, LISTENER.ORA and SQLNET.ORA.If there is any syntax issues with those files, including control characters, etc, Then the operation can fail. SOLUTION: Use the GUI Net manager tool to […]
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 […]
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 […]
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 […]
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 […]
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 […]
This is official Blog of Dbametrix Solutions. Dbametrix is group of companies for providing database services and database dba support to global client with exclusive remote support system using strong and transparent SLA and response time matrix with low cost plans.