|
Solution Search:
Most Popular
|
Related Expert Advice
Setting events to avoid "snapshot too old" errors
In order to identify offending statements in "ORA-1555: snapshot too old" errors, can you please let me know how to set events? I have seen in Oracle forums to set "alter session set events = '1555 trace name errorstack level 1'." But this was for Oracle 8.1.7. Our database is version 9.2.0.6.0. Is this event valid for version 9.2.0.6.0. as...
More...
Jul 27, 2006
Analyzing wait events in Oracle
The next step is to determine where the query is spending its time waiting. For that, you'll have to look at the query's wait events. The following URL's show some information on wait events:
Oracle Performance Tuning Using Event Interpreting Wait Events To Boost System Performance (PowerPoint presentation download) ... More... May 1, 2008
Understanding a STATSPACK report
report? The STATSPACK report is an offshoot of the old bstat-estat report, which was created for Oracle internal-use only and is not documented by Oracle. Many of the performance metrics are also undocumented and require detailed knowledge of Oracle internals.
Understanding all the sections of a STATSPACK report... More... Related Solution Center
The relational data model
Here you'll find an introduction to the relational model with reference to the Oracle proprietary Relational Database Management System (RDBMS...
More...
Jun 25, 2003
Relational model
The relational model has never been fully implemented, but it still provides the basis for most modern database technology. This article describes the relational model and its advantages and...
More...
Jun 17, 2003
Introduction to relational databases
An excellent primer on relational databases, this article describes Codd's 12 rules, database design, keys and normalization...
More...
Jun 17, 2003
|