Article Tag Cloud

Display :
Category: Programming

The Major 13 Differences between Oracle 9i, 10 and 11g

Oracle is a database management scheme which is highly accepted. It is basically used in the basis that it helps in perfectly managing a large amount of data. It is mainly used because it is platform free and usable in any platform. It is dependable and gives many options. There are many types or versions of Oracle.

The following are the major differences between Oracle Internet Directory 9i, 10, 11g:

Category: Programming

Server Load Balancing: A Convenient Solution

As basically defined, server load balancing is a technique that executes distribution of work load  to achieve optimizing internet protocol traffic that can be efficiently perform between network servers or server farm using numerous methods with the intention of preventing overloading of a single server . In busy and high accessibility server clusters, server load balancing is mostly significant, since quantity of demand to be forwarded to a server is hard to expect.

Category: Programming

Comparative Study on Oracle and SQL

                     

Oracle History:

Category: Programming

                                                              SQL-related Stored Procedures (SP)

Normally, a stored procedure is said to be an independent module of programming instructions accessible to submissions getting into a ‘relational’ DB scheme. Stored procedures, which are also known as sproc, proc, StoPro, SP or StoredProc, are retained in the data dictionary of your database.

Category: Programming

                             SQL, How To Select Columns, Rows And Join Tables

Selecting Specific Columns From a Table:

Category: Programming

Basic PHP

Introduction

Category: Programming

Service Oriented Architecture

Service Oriented Architecture is a technique used in software development based on the concept of Service.  A service can be defined as an independent function which is well defined and self contained. In SOA different services communicate each other to perform some activity. Even two or more services can be synchronized together to perform some complex activities.

Category: Programming

Oracle \ Data dictionary cache \ database buffer cache \ redo log caches add any others.

Oracle Memory Cache/Architecture: Oracle uses memory to store different pieces of information, like Program Code, Connected session, if it not currently active with any or different user, Information needed when program executive (Locking Information), and last Cached Data on peripheral memory.