I've been asked by the publishers to review "Oracle Database 11g Release 2: Performance Tuning Tips and Techniques" by Richard Niemiec of TUSC. Conclusion: it is good but not perfect. This is an extended version of the review I put up on Amazon.
Dependency Oracle schema is the place where all the Database objects get stored. This make a room for the entire set of objects under the Category of Data Storage ( Tables, Views) and Data Access (Stored Procedure ,Functions ,Packages and Triggers) .These Objects make a reference across all these objects to form the application.This is known as dependency.
Conventional Dependency Model If an Object B is being referrd from object A (ie Object A refers another Object B) , Object A is known as Dependant Object and Object B is Known as referenced Object.
Basics of Partition Tables
Partitioning is a method of splitting an object (a table or index) into separate parts (called partitions) based on some criterion that is assigned to the partition. The criterion might be a date range, a number range, or any other possible value. Imagine, for example, that you have a huge table that is driving you crazy because queries on it are really slow. You get so mad at this table that you take a logical hatchet and begin to slice the table up into many smaller tables is a partition.
Below are some ORA-ERROR which every DBA face:
Clause: Most likely it is related to bug
Solution: go to metalink and apply patch set.
Clause: It is generic error means lots of reason behind this.
Solution: Depends on condition but best way to search on google/forms.
Clause: Mis-configuration of SGA, insufficient memory
Solution: Sametime need to add memory on system, or sametime need to reduce SGA memory
Oracle 18.104.22.168, the second patch set for the 11gR2 database, is now certified with with E-Business Suite and is available for download in 32 and 64-bit.
You can download it from only your meta link account credential.
Patch No: 10404530
Oracle E-Business Suite Release 11i
* 22.214.171.124 + ATG PF.H RUP 6 and higher
* Linux x86 (Oracle Linux 4, 5)
* Linux x86 (RHEL 4, 5)
* Linux x86 (SLES 10)
* Linux x86-64 (Oracle Linux 4, 5)
One of the great features about partitioning, and most specifically range-based partitioning, is the ability to load data quickly and easily with minimal impact on the current users using:
alter table call exchange partition data_2007 with table call_temp;
LOBs deal with unstructured data, the ones which are the most difficult to store and retrieve in a relational database.
In this article, I am going to discuss extensively and manipulate the ORACLE
* LOBs that are stored in the database itself like BLOB,CLOB,NCLOB ,and
* LOBs like BFILE which are Stored outside the database as Operating System files.
First let us create a directory :
create or replace directory my_dir as 'D:\pics';
BFILEs act as a pointer and store the location of the external OS files in database tables.
I am sharing a nice article on RTF template design written by one of our senior consultant Mr. Venkat from Adiva Consulting.
The objective of this post is to explain the “sorting” capabilities available in the RTF. Many might
already be aware of the standard BI Publisher syntax for sorting in the RTF template:
The above construct sorts the data by the VENDOR_NAME in ascending order – an alphabetic sort
is performed. However, what if the requirement was to sort on a number field.
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
ORA-00214: control file
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL02.CTL' version 23659
inconsistent with file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\JOHNSON\CONTROL01.CTL'
SQL> shutdown abort;
ORACLE instance shut down.
sQL>create pfile='c:/initnew.ora' from spfile;
Performance Improvement in Pro*C
Pro*C code compilation builds executable depends on the parameters passed while compiling a code on Linux OS. GCC compiler is widely used for compilation.
Parameters that it provides enables memory management and linking etc...
This means : Without changing Code GCC compilation parameter change can give significant improvement in performance without impacting functionality. Attached document contents details study of the same.
This document gives details about environment,deployment and pre-post change analysis.
Sanjay J. Sontakke