RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Web Applications
«Prev
Next»
Performance Tuning
Data Blocks
Database Block Size
Optimizing Space Usage
Segment Header Internals
Data Block Fundamentals
PCtfree Optimal Performance
PCtused Optimal Performance
PCT Used Optimal Performance
PCT Used Performance
Setting PCT Used Guidelines
Monitoring Tuning Indexes
Monitoring Tuning Indexes
Analyzing Oracle Index
Table High Water Marks
Water Mark Active
DB Engine Conclusion
Data Structures
Oracle Structures
Abstract Data Types
Using Oracle Objects
Oracle nested Tables
Oracle Data Constructs
Oracle Varrays
Performance Conclusion
Data Dictionary
Performance Views
DBA Performance
Buffer hit Ratio
Building Alert Monitor
Oracle Data Dictionary
x-views
Partitioned Tuning
Partitioned Objects
Database Objects
Global Partitioned Indexes
Local Partitioned Indexes
Partitioned Index Maintenance
DB Partitioned Features
Index Techniques
Bitmap Indexes
Increase Query Speed
DW Star Schema
Star Transformation Queries
Star Transformation Process
Transformation Process
Using Concatenated Indexes
Function Based Indexes
Bitmapped Indexes
Oracle Database Tuning
Oracle Web Applications
Web Request Broker
Oracle Tuning - Glossary
Oracle Execution Plan Techniques - Quz
Advanced Execution Plan Techniques
1.
Which were listed as tuning techniques for Web-based Oracle applications?
Please select all the correct answers.
A.
Use alternative locking mechanisms to avoid the SELECT FOR UPDATE clause
B.
Place the WebServer software on a separate computer
C.
Pre-aggregate any summary information that may be requested from the Web
D.
Limit the amount of returned Oracle data to the amount of data that the end-user will immediately require
2.
Which platform layer would contain the WRB and the Web Listener?
Please select the best answer.
A.
The client platform
B.
The application server platform
C.
The database server platform
3.
Which were listed as reasons for avoiding the SELECT FOR UPDATE with Web applications?
Please select all the correct answers.
A.
The Web connections are unreliable, and a disconnected client can lead to zombie locks in the shared pool.
B.
Disconnected clients can lead to unnecessary wasted memory in the data buffer memory.
C.
Disconnected clients can lead to unnecessary row locks.
D.
Disconnected clients can lead to runaway tasks, causing Oracle performance degradation.