Antonio Alvarado Hernández's Library tagged to:Oracle →  View Popular

This book is designed to bridge the gap between the many PHP and the many Oracle texts available. It shows how to use the PHP scripting language with the Oracle database, from installation to using them efficiently.

www.oracle.com/...erground-php-oracle-manual.pdf - Preview

database development Oracle PHP book resource

Oracle Corporations developer Vadim Tropashko has some interesting notes on tuning Oracle SQL queries that compare the contents of two tables, showing several SQL solutions and their performance with
(tags: trick tip table sql resource oracle database c

www.dba-oracle.com/_set_to_join_sql_parameter.htm - Preview

trick tip table sql resource database compare article Burleson Oracle

Oracle provides table and index maintenance tools (Oracle 10g online reorganization) for a very good reason. To keep Oracle running super-fast, Oracle chose not to incur the overhead of coalescing ta
(tags: tuning tip resource oracle maintenance databas

www.dba-oracle.com/ligent_10g_DBA_maintenance.htm - Preview

tuning tip resource maintenance database coalescing article Burleson Oracle

Oracle SQL tuning is a phenomenally complex subject. Entire books have been written about the nuances of Oracle SQL tuning; however, there are some general guidelines that every Oracle DBA follows in
(tags: tuning trick tip sql resource performance oracl

dba-oracle.com/art_sql_tune.htm - Preview

tuning trick tip sql resource performance database article Burleson Oracle

Oracle includes numerous data structures to improve the speed of Oracle SQL queries. Taking advantage of the low cost of disk storage, Oracle includes many new indexing algorithms that dramatically in
(tags: tuning resource performance oracle indexing da

dba-oracle.com/art_9i_indexing.htm - Preview

tuning resource performance indexing database article Burleson Oracle

At Oracle Openworld 2006, Oracle announced some exciting new features of Oracle 11g, and they promise 482 new Oracle11g features. For me, the most exciting new features relate to tools that automate
(tags: resource release oracle new feature database bu

dba-oracle.com/...oracle_11g_new_features.htm - Preview

resource release new feature database article 11g Burleson Oracle

Oracle stored procedures and triggers are faster than traditional code, which leads to an increase in popularity. As application code moves away from external programs and into the database engine, DB
(tags: using trick tip stored resource procedure orac

www.dba-oracle.com/art_proc.htm - Preview

using trick tip stored resource procedure database article Burleson Oracle

One of the most effective tools for forecasting Oracle performance is the time-series data in STATSPACK and the Automatic Workload Repository in Oracle 10g. Using this time-series information, the Or
(tags: time-series resource release predictive oracle

www.dba-oracle.com/ps_predictive_modeling_10g.htm - Preview

time-series resource release predictive modeling forecasting database article 10g Burleson Oracle

Oracles cost-based SQL optimizer (CBO) is an extremely sophisticated component of Oracle that governs the execution for every Oracle query. The CBO has evolved into one of the worlds most sophistica
(tags: resource oracle optimization database cost bur

www.dba-oracle.com/art_otn_cbo.htm - Preview

resource optimization database cost based article Burleson Oracle

Oracle has improved the cost-based Oracle optimizer in 9.0.5 and again in 10g, so one of the most common causes of bad performance right after moving to 10g are related to environmental parameter sett
(tags: tuning tip resource release oracle migration d

www.dba-oracle.com/_performance_after_upgrade.htm - Preview

tuning tip resource release migration database article 10g Burleson Oracle

The Oracle STATSPACK utility (and its successor, AWR), is one of the most exciting Oracle enhancements. This article will introduce you to the STATSPACK and AWR utility and show you how to put it to
(tags: tip statspack resource rdbms performance oracle

dba-oracle.com/art_statspack.htm - Preview

tip statspack resource rdbms performance monitor database article Oracle

Because all Oracle databases retrieve and store data, the relative cost of physical disk access is an important topic.
(tags: tuning tip resource performance oracle io database article)

www.dba-oracle.com/art_builder_io_speed.htm - Preview

tuning tip resource performance io database article Oracle

If you dont want to use dbms_redefinition, or the CTAS statement is one method for reorganizing an Oracle table or moving the table to another tablespace.
(tags: tip table resource reorganize oracle database create article)

www.dba-oracle.com/t_create_table_select_ctas.htm - Preview

tip table resource reorganize database create article Oracle

This article will examine the realities of hardware advances and show how the Oracle systems manager can make an intelligent decision about when to move to faster hardware platforms.
(tags: upgrade tip resource rdbms oracle hardware database article)

www.dba-oracle.com/t_hardware_upgrade.htm - Preview

upgrade tip resource rdbms hardware database article Oracle

(tags: wiki resource oracle)

wiki.oracle.com - Preview

wiki resource Oracle

(tags: resource remote oracle bkm-imported-through-opera)

www.ixora.com.au - Preview

resource remote bkm-imported-through-opera Oracle

(tags: tips reference plsql oracle development database)

www.psoug.org/library.html - Preview

tips reference plsql development database Oracle