What Is Dynamic SQL?
Dynamic SQL enables you to write programs that
reference SQL statements whose full text is not known until runtime.
Wednesday, September 4, 2013
How to clone the Oracle database software
This blog post describes the process of cloning an Oracle Home - in this case we are
cloning a 11g Release 2 Oracle Home from source machine devastator to target
machine vixen.
On source (devastator)
ORACLE_HOME
location is : /u01/app/oracle/product/11.2.0/dbhome_1
Go
to directory on source machine one level higher and tar the db_home1 directory
and all sub-directories
How to use SQL Tuning Advisor in Oracle 10G
1
Introduction
Purpose
SQL tuning is one of the challenging
tasks faced by Database Administrators. It is an interesting and creative, but
at the same time, daunting task. Manual tuning of SQL statements requires
through knowledge of how the statements are executed in the background and experience
to understand suitable access paths to yield better response times. Moreover,
in a typical application, there are just too many SQL statements to tune and
advise the developers.
Tuning Oracle Database Basics
1
Introduction
Purpose
One
of the biggest responsibilities of a DBA is to ensure that the Oracle database
is tuned properly. The Oracle RDBMS is highly tunable and allows the database
to be monitored and adjusted to increase its performance.
Subscribe to:
Posts (Atom)