Posted in Oracle Database on March 31, 2008 | 2 Comments »
Tingkat: Pemula
DB Version: 10.2.0.1 above
Database yang sudah ter-create dapat kita clone menggunakan DBCA. Hasil clone ini akan disimpan sebagai template.
Pertama, jalankan dbca:
Klik tombol Next, maka kita masuk ke step 1. Pastikan Manage Templates terpilih. Kemudian klik tombol Next:
Pada step 2, Pilih Create a database template dan From an existing database (structure as well as data), [...]
Posted in Oracle Database on February 28, 2008 | Leave a Comment »
In this Document
This document is being delivered to you via Oracle Support’s Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.
Applies to:
Oracle Warehouse Builder – Version: 11.1
Information in this document applies to any platform.
Goal
How to start the Warehouse Builder Repository [...]
Posted in Oracle Database on February 28, 2008 | Leave a Comment »
James Koopmann, jkoopmann@pinehorse.com
Introduction
Do you know how your disk subsystem is actually performing? This article looks at extracting various I/O statistics so that you can monitor and determine just how well your disks are doing.
How can I separate Oracle I/O to maximize performance?
Should I separate data files from index files?
Should I separate redo logs”
These [...]
Posted in Oracle Database on February 20, 2008 | Leave a Comment »
Author: Burleson
It is very frustrating when you find your database hang. It is even more frustrating when there are no messages in the alert log and still you are unable to connect to the database. We hear complains when one tries to connect to Oracle with Enterprise Manager and it just hangs. Sometimes one [...]
Posted in Oracle Database on February 20, 2008 | 2 Comments »
Author: Burleson
TNS or Transparent Network Substrate is Oracle’s networking architecture. Oracle typically relies on TNS to provide generic network connectivity to and between Oracle databases. TNS provides a uniform application interface to enable network applications to access the underlying network protocols transparently.
It is very critical for Oracle professional to understand the affect of network configuration [...]
Posted in Oracle Database on February 20, 2008 | Leave a Comment »
Author: Burleson
Locking is a very important part of any database system. Database table locks are coordinated through global inter-instance communication for RAC. It is the fact that properly designed applications need not to lock entire tables and therefore table locks can be disabled to improve locking efficiency with minimal adverse side effects.
Disabling Oracle Table Locks: [...]
Posted in Oracle Database on February 20, 2008 | Leave a Comment »
Author: Burleson
With every release of Oracle we see many configuration and manageability enhancements. Many issues have been rectified and many facilities are provided to make the life of database administrator easier.
RMAN utility can be used to copy the database structures and metadata when you instantiate an entire database for Oracle Streams. The database cloning method [...]
Posted in Oracle Database on February 19, 2008 | Leave a Comment »
Author: Mike Mortensen
In this article I will give some useful tips that will help you avoid PL/SQL performance problems. Most of work in PL/SQL programs is done by SQL statements and hence slow SQL statements are the main reason for slow execution. The loops and inside code must be optimized to gain [...]
Posted in Oracle Database on February 19, 2008 | Leave a Comment »
Author: Adrian Billington
Oracle 10g enables PL/SQL developers to trap AND log exceptions accurately. The DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function provides the flexibility and information that DBMS_UTILITY.FORMAT_ERROR_STACK function simply didn’t provide.
Low Level of Information:
Many PL/SQL developers become satisfied with the level of information described below. They take screen scrapes of their scheduling systems’ output as application logs or perhaps [...]
Posted in Oracle Database on February 19, 2008 | Leave a Comment »
Author: R. Nyffenegger
In this article I will discuss some great tips about Oracle flashback. You can use the as of clause in a select statement to see the data as of a past SCN or past point in time. This [...]
