Professional Custom Accounting papers: What has memory and I/O have to do with tuning of an Oracle Database?

Professional Custom Accounting papers: What has memory and I/O have to do with tuning of an Oracle Database?

A: Would SQL queries lead to performance bottlenecks in an Oracle Database and how would you eliminate this problem?

B: Provide an example of a complex SQL statement (one which joins multiple tables, uses aggregate functions or subqueries) and review the process in which you would examine the performance of the SQL statement as well as how you would adjust the statement.

Question 2 .

Memory and tuning What has memory and I/O have to do with tuning of an Oracle Database? Please explain.