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 […]
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 […]
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 […]
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. […]
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 […]
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 […]
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 […]
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.