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

A snapshot is created on a destination system with the CREATE SNAPSHOT command, and the remote table is immediately defined and populated from the master table.

www.remote-dba.net/_snapshots_create_snapshot.htm - Preview

snapshot howto replication distributed database to:Oracle article Burleson

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 to:Oracle

A personal blog from a freelance Oracle DBA, with interesting Oracle resources, tips and tricks.

boulayp.free.fr - Preview

database Oracle tip trick script utility blog resource to:Oracle

This article describes my work in creating end-user login/logoff procedures to facilitate tracking end-user activity. Please be advised that the initial implementation of system-level triggers for end
(tags: user triggers system oracle howto database bur

dba-oracle.com/art_builder_sec_audit.htm - Preview

user triggers system howto database auditing article activity to:Oracle Burleson

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 to:Oracle Burleson

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 to:Oracle Burleson

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 to:Oracle Burleson

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 to:Oracle Burleson

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 to:Oracle Burleson

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 to:Oracle Burleson

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 to:Oracle Burleson

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 to:Oracle Burleson

Every year, young computer professionals leave the hallowed halls and ivory towers of college and survey the landscape for computer jobs. They look at the salary surveys and drool at the prospect of
(tags: oracle howto dba database burleson become)

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

howto dba database become to:Oracle Burleson

Cloud computing has been touted as a radical "paradigm shift", where IT power is delivered to an application over the internet as you need it, rather than drawn from a centralized server. Re
(tags: oracle distributed database computing cloud burleson)

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

distributed database computing cloud to:Oracle Burleson

Oracle disk manufacturers are starting to recognize their imminent displacement by solid-state disks and things are not always as they seem when looking at disk manufacturer’s specifications. Read ab
(tags: top resource oracle obsolete disk database bur

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

top resource obsolete disk database article to:Oracle Burleson

PL/SQL has become a mature and popular language since its introduction in 1991, yet the language is still relatively young compared to its ancestors (both direct ancestors, like Ada, and indirect ance\n (tags: standard resource practice oracle database bur

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

standard resource practice database best article to:Oracle Burleson

Materialized views are an Oracle Silver Bullet when pre-joining tables together for super-fast response time. One issue with highly-normalized, non-redundant Oracle table designs (e.g. third normal fo
(tags: view resource partitioning oracle materialized

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

view resource partitioning materialized database article to:Oracle Burleson

There are many compelling reasons to migrate directly to Oracle 10g release 2. Oracle 10g is very stable and there are many administrative and performance benefits to justify a migration to Oracle 10
(tags: resource release oracle migration justificatio

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

resource release migration justification database article 10g to:Oracle Burleson

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 to:Oracle Burleson

What are the most common root-causes of poor Oracle performance? Every expert will give you a different opinion, but I’ve prepared my list based on our hundreds of Oracle tuning engagements.
(tags: top resource poor performance oracle database burleson

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

top resource poor performance database article 10 to:Oracle Burleson