Logo DWBI.org Login / Sign Up
Sign Up
Have Login?
Login
New Account?
Recovery
Go to Login
Database

Oracle

 

Oracle is a relational database management system developed by Oracle Corporation. Related articles and tutorials on Oracle database is presented under this section.

12 Articles
0 Sub-categories
Articles

Learn Oracle Server Architecture in 10 minutes

Here is an easy to understand primer on Oracle architecture. Read this first to give yourself a head-start before you read more advanced articles on Oracle Server Architecture.

Updated 29 Sep, 2020

Read More

Oracle External Tables

The Oracle external tables feature allows us to access data in external sources as if it is a table in the database. This is a very convenient and fast method to retrieve data from flat files outside Oracle database.

Updated 29 Sep, 2020

Read More

Different Methods to move data from Oracle to External File

How to push data from Oracle Table to external files? Well, external tables in Oracle provides a way to move data in as well as out of the database with the help of SQL*Loader and Data Pump functionality.

Updated 29 Sep, 2020

Read More

Oracle UTL_FILE

The Oracle supplied PL/SQL package UTL_FILE used to read and write operating system files that are located on the database server.

Updated 29 Sep, 2020

Read More

Oracle Spool

Oracle Spool for SQLplus command line utility, can be used in conjunction with OS to export data from Oracle to flat file.

Updated 29 Sep, 2020

Read More

Oracle Analytic Functions

Oracle Analytic Functions compute an aggregate value based on a group of rows. It opens up a whole new way of looking at the data. This article explains how we can unleash the full potential of this.

Updated 30 Sep, 2020

Read More

How to find out Expected Time of Completion for an Oracle Query

Too often we become impatient when Oracle Query executed by us does not seem to return any result. But Oracle (10g onwards) gives us an option to check how long a query will run, that is, to find out expected time of completion for a query.

Updated 30 Sep, 2020

Read More

How to find out Which User is Running what SQL Query in Oracle database?

Do you wonder how to get information on all the active query in the Oracle database? Do you want to know what query is executed by which user and how long is it running? Here is how to do it!

Updated 30 Sep, 2020

Read More

Database Performance Tuning

This article tries to comprehensively list down many things one needs to know for Oracle Database Performance Tuning. The ultimate goal of this document is to provide a generic and comprehensive guideline to Tune Oracle Databases from both programmer and administrator's standpoint.

Updated 30 Sep, 2020

Read More

Understanding Oracle QUERY PLAN - A 10 minutes guide

Confused about how to understand Oracle Query Execution Plan? This 10 minutes step by step primer is the first of a two part article that will teach you exactly the things you must know about Query Plan.

Updated 30 Sep, 2020

Read More

Understanding Oracle QUERY PLAN - Part2 (Exploring SQL Joins)

This is the second part of the article Understanding Oracle Query Plan. In this part we will deal with SQL Joins.

Updated 30 Sep, 2020

Read More

Oracle AUTOTRACE Explained - A 10 Minute Guide

AUTOTRACE is a beautiful utility in Oracle that can help you gather vital performance statistics for a SQL Query. You need to understand and use it for SQL Query Tuning. Here is how!

Updated 30 Sep, 2020

Read More
Sub-categories

No sub-category under this category