Recent Articles

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

What is VPN?

What is VPN?

January 10, 2019 | By | Add a Comment

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

Read More

Assertions and Deferability of Constraints

Assertions and Deferability of Constraints

January 10, 2019 | By | Add a Comment

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

Read More