Partitioning the Tables in Oracle database is an important aspect when it comes to Performance Management.As the number of rows in table increases,The performance impacts wil increase Backup and recovery process may take longer time than usal and sql queries that affecting entire table will take loger time. we can reduce the performance issue causing [...]
Written by admin on March 26th, 2011 with comments disabled.
Read more articles on Home.
The Standards for C,C++ and SQL were designed to enable Application portability.To achieve this portability it is necessary that both platforms must confirm to the international standards.The SQL/2 standard supports embedding sql statements in other languages.Oracle’s embedded SQL environment is called Pro*C.This Tutorial shows how to embed sql statements in C or C++. A C [...]
Written by admin on February 15th, 2011 with comments disabled.
Read more articles on Pro *C.
UTL_FILE_DIR parameter allow you to specify one or more directories where you can do input/output operations in PL SQL.These file can be written and can be read using UTL_FILE Package. syntax for setting UTL_FILE_DIR is alter system set UTL_FILE_DIR = ‘/tmp’ scope=spfile; Specifying multiple directories in the spfile alter system set utl_file_dir=’/tmp/dir1′,’/tmp/dir2′,’/tmp’ scope=spfile In the [...]
Written by admin on January 28th, 2011 with comments disabled.
Read more articles on Oracle Initialization Parameters.
Programmers often need a way to count and/or add up variable conditions for a group of rows. The DECODE statement provides a very efficient way of doing this. Because DECODE is rather complex, few programmers take the time to learn to use this statement to full advantage. The following statement uses DECODE to count the [...]
Written by admin on January 27th, 2011 with comments disabled.
Read more articles on Oracle Tuning.
you can use alerts to notify you about an event for informational purposes. The DBMS_ALERT package is typically a one-way asynchronous communication that is triggered when a transaction commits. Unless a transaction commits, no information is sent to the alert. This means that a waiting procedure or application remains idle until the desired transaction commits. [...]
Written by admin on January 19th, 2011 with comments disabled.
Read more articles on Oracle Packages.
Automatic Storage Management (ASM) provides a centralized way to manage Oracle Database disk storage.In this,we will discuss what ASM is, how to configure an ASM instance, how to manage an ASM instance, and finally, how to use ASM from within an Oracle database. What is ASM? ASM is designed to simplify Oracle database storage administration. Database [...]
Written by admin on January 1st, 2011 with comments disabled.
Read more articles on Oracle ASM.
SQL Trace causes trace files to be produced by Oracle Database. Various items of interest are generated into trace files. This information comprises details of CPU and I/O needs plus parsing and execution information, processed rows, commits, and rollbacks. The output in trace files is more or less impossible to interpret by hand. Setting up [...]
Written by admin on December 29th, 2010 with comments disabled.
Read more articles on Oracle Tuning.
There are number of reasons due to which run time errors may be raised during the execution of a PL/SQL block. With PL/SQL, a mechanism called exception handling lets you “bulletproof” your program so that it can continue operating in the presence of errors. When an error occurs, an exception is raised; normal execution is [...]
Written by admin on December 21st, 2010 with comments disabled.
Read more articles on Exception Handling.
RDBMS stands for Relational Database Management System.In RDBMS data is structured in database tables, fields and records.RDBMS store the data into collection of tables, which might be related by common fields (database table columns). RDBMS also provide relational operators to manipulate the data stored into the database tables. Most RDBMS use SQL as database query [...]
Written by admin on December 21st, 2010 with comments disabled.
Read more articles on RDBMS.
Pseudocolumns are not really columns in a table; they just have characteristics of columns. These pseudocolumns will return values when referenced just like real table columns. However, you cannot do any other DML or DDL statements on these pseudocolumns. Pseudocolumns are primarily used to give the programmer more tools to use in his code. They [...]
Written by admin on December 18th, 2010 with comments disabled.
Read more articles on SQL tutorials.