| Home : Career Articles |
| Click "Subscribe" if you want to be notified of new or updated links in this category. | Subscribe |
|
|
Career Articles Listings
|
|
Total:
188 | Displaying: 121 - 130 | Pages: << 4 5 6 7 8 9 10 11 12 13 >> |
|
|
|
TUNING ROLLBACK SEGMENTS - Have enough rollback segments so that transactions never wait for access to rollbacks, Avoid frequent dynamic extention of rollback segments (overhead).
Updated: 10/22/2005
|
|
|
Using Oracle Blocks Efficiently - Minimize dynamic allocation of extents: Use locally managed tablespaces (using EXTENT MANAGEMENT LOCAL clause). Sizing segments appropriately (larger extents have a performance benefit). Make all extents a multiple of 5 *
Updated: 10/22/2005
|
|
|
A cache miss on the library or dictionary cache is MORE expensive than a DB buffer miss. Concentrate on tuning library cache since Oracle holds dictionary data in memory longer. If too small, resources must be dedicated which consumes CPU and causes contention. Free memory in shared pool is considered wasted space and is often a sign of fragmentation.
Updated: 10/22/2005
|
|
|
In this section we will be covering Performance and Tuning. Please use this as reference before going to any interview and Certification exams.
Updated: 10/22/2005
|
|
|
Profiles: · Contain password aging and expiration, history, verification and account lock info. · Contain resource limits (CPU, IO, idle time, connect time, sessions) Per session or per call.
Updated: 10/22/2005
|
|
|
Managing Indexes:- B-TREE leafs store lists of rowids. High cardinality Inexpensive key updates Not good for OR queries, Useful in OLTP , Bitmap index leafs store bitmap pointer , Low cardinality (more compact) , Very expensive key updates, Good for OR queries , Better for Data Warehousing
Updated: 10/22/2005
|
|
|
Tablespace and Data Files:Locally Managed Tables · Use bitmaps versus data dictionary => Less contention on dictionary .· No rollback is generated (no dictionary table updates). · No coalescing is needed (automatic tracking of adjacent free space).
Updated: 10/22/2005
|
|
|
We will be providing the Interview and Certification Pracitce notes like a quick reference in Oracle Administration and Architecture, Performance Tuning, Back and Recovery. This is all you need to be able to answer most of the Interview Questions and also helps with the Oracle DBA Certification.
Updated: 10/22/2005
|
|
|
Please find Technical Support Position Interview Questions. If you have any from your experience please send them to us. We will update this article. These questions can be found in EFS Repository in PDF format.
Updated: 10/22/2005
|
|
|
We updated MicroProcessor Interview Questions as per our members request. Please find the questions below. PLease post the answers in the Disucussion board if you know them .
Updated: 10/22/2005
|
|
|
Career Articles Listings
|
|
Total:
188 | Displaying: 121 - 130 | Pages: << 4 5 6 7 8 9 10 11 12 13 >> |
|
|
