Antonio Alvarado Hernández's Library tagged → View Popular
Oracle Tecnology Network: Oracle Call Interface (OCI)
When applications developers demand the most powerful interface to the Oracle Database Server, they call call upon the Oracle Call Interface (OCI). OCI provides the most comprehensive access to all of the Oracle Database functionality. The newest performance, scalability, and security features appear first in the OCI API.
Burleson: Distributed Oracle Data Warehouses - How snapshots works
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.
Burleson: Oracle reactive monitoring tools
There is an important distinction between reactive, and proactive Oracle tuning. This article talks about reactive monitoring tools.
The Underground PHP and Oracle Manual
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.
Patrick Boulay's Blog
A personal blog from a freelance Oracle DBA, with interesting Oracle resources, tips and tricks.
Burleson: Auditing and reporting Oracle user activity
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
Burleson: How to become an Oracle DBA
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)
Burleson: Inside Oracle cloud Computing
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)
Burleson: Why disks are obsolete
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
Burleson: PL/SQL best practice standards
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
Burleson: Oracle materialized views and partitioning
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
Burleson: Justifying a migration upgrade to Oracle 10g
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
Burleson: Top 10 Reasons for poor Oracle performance
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
Burleson: Speed Oracle SQL with Temporary Tables
For certain types of SQL operations, the creation of intermediate result tables can result in stunning performance improvements. We will discuss how you can use the global temporary tables (GTT) synta
(tags: temporary table resource rdbms oracle database
Burleson: Super fast Database Copying/Cloning
This Oracle clone procedure can be use to quickly migrate a system from one UNIX server to another. It clones the Oracle database and this Oracle cloning procedures is often the fastest way to copy a
(tags: resource rdbms oracle fast database cloning ar
Burleson: Understanding Oracle physical disk I/O metrics
When Oracle makes a physical I/O request, its handed-off to the operating system as a native I/O operation. At this layer, the device-media interface takes over, as Oracle patiently waits for the bl
(tags: resource rdbms physical oracle metric disk dat
Burleson: Automatically tuned multi-block reads in 10g
Is it already reliable to use "Automatically Tuned Multiblock Reads" with 10g or should one still run with an as high as possible setting for db_file_multiblock_read_count? Are there any dra
(tags: tuning tuned resource read rdbms parameter oracle multib
Insight Technology, Inc: Ora! Ora! Oracle Magazine
Ora! Ora! Oracle is weekly mail magazine dedicated to Oracle users.
(tags: resource oracle magazine database)
Selected Tags
Related Tags
Sponsored Links
Top Contributors
Groups interested in Oracle
Highlighter, Sticky notes, Tagging, Groups and Network: integrated suite dramatically boosting research productivity. Learn more »
Join Diigo
