Books for you

For example, to
solve slow I/O, you might try restriping or adding throughput to the disk subsystem.
However, this situation could be caused by poorly tuned SQL and would thus be
better fixed by rewriting the SQL.
At this point, you should analyze the interaction of individual modules and SQL
statements in your application system and the database server. You could find that a
handful of SQL statements are causing your performance problem. However, it??™s
more likely that you will have to reconsider the design of your application system.
Enterprise Manager and the Automatic Database Diagnostic Monitor (ADDM) can
automatically identify SQL statements that are using the most resources or are less
than optimal??”the SQL Tuning Advisor component can even suggest solutions for
the identified performance problems. (These tools are described later in this chapter.)
Needless to say, more complex application redesign is far beyond the scope of this
book, so the rest of this chapter will concentrate on helping youto understand Oracle
machine resources.


Pages:
335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359