 |
|
|
|
|
|
Oracle database performance problems and tuning
|
|
 |
|
|
|
|
| ORACLE DATABASE PERFORMANCE PROBLEMS AND TUNING EXPERTS |
|
|
|
|
|
|
Paul Baumgartel
Senior Database Administrator and Consultant
ASK A QUESTION |
|
|
|
|
|
|
|
|
Building an index
Expert: Paul Baumgartel | 22 Jun 2004
EXPERT ANSWER - How do I build an index?
|
|
|
Best means for capacity planning
Expert: Paul Baumgartel | 22 Jun 2004
EXPERT ANSWER - What is the best means to do capacity planning? We have transaction counts and such, but we are not sure what really gives an accurate view of the load on the server, and we need to justify clustering and a SAN.
|
|
|
Getting best Oracle performance on Win2000
Expert: Paul Baumgartel | 22 Jun 2004
EXPERT ANSWER - We are running Oracle 8.1.7.4 on Windows 2000 Advanced Server for our
ERP (Oracle Apps 11.5.8). We are facing the problem of performance. Oracle.exe is not going beyong 3GB even if we have physical RAM of 6 GB. We use PAE ...
|
|
|
Reading, writing and reporting on queries
Expert: Paul Baumgartel | 10 Jun 2004
EXPERT ANSWER - Do you know of either a script or bat file that can read 100 individual
query files, connect to a database, do EXPLAIN on each query and write the
EXPLAIN report on each query in batch mode?
|
|
|
Indexing in 10g
Expert: Paul Baumgartel | 10 Jun 2004
EXPERT ANSWER - Is indexing in 10g different from 8i or 9i?
|
|
|
Changing redo log buffer size
Expert: Paul Baumgartel | 10 Jun 2004
EXPERT ANSWER - How do I change the redo log buffer size, the shared pool size and the
database buffer pool size? I know its all in the init.ora file, but what
exactly do I change? Also how can I then check to see if my changes
actually ...
|
|
|
Calculating I/O size
Expert: Paul Baumgartel | 10 Jun 2004
EXPERT ANSWER - I am trying to correlate the db_block_size and
db_file_multiblock_read_count. I have the block size of 8k. Is 16k block
size equivalent to increasing the db_file_multiblock_read_count (I know
internally not but throughput ...
|
|
|
Most common cause of performance problems
Expert: Paul Baumgartel | 27 May 2004
EXPERT ANSWER - I have been tasked with identifying ways we can tune our Oracle database
for better performance. First, I want to know what are the most common
causes of oracle db performance problems? What should I be looking for
and ...
|
|
|
Tuning a new database vs. existing database
Expert: Paul Baumgartel | 27 May 2004
EXPERT ANSWER - Are there differences when tuning a new database (just
installed/upgraded) compared to an existing database? Should I approach
tuning differently in one case?
|
|
|
|
|
|
|
|
|
| TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of . |
|
| | |
All Rights Reserved, , TechTarget |
|
|
|
|
|
