CSCI317 Database Performance Tuning, "How to ... ?" Cookbook

CSCI317

Database Performance Tuning

"How to ... ?" Cookbook

Oracle Database 19c

	1	How to access Oracle 19c database server, how tu use SQL Developer, how to use basic SQL and SQLcl, and how to create a sample database ?
	2	How to use TIMING, AUTOTRACE, and dynamic performance (V$) views
	3	How to find SQL processing plans and how to use hints ?
	4	How to use SQL_TRACE, "pseudo-error debugging event 10046", and "tracing event 10053" ?
	5	How to create statistics and histograms, how to control cost based query optimizer, how to monitor DML operations, and how to create outlines ?
	6	How to shut down and start up Oracle database server, how to find and how to change the values of system initialization parameters, how to investigate System Global Area (SGA), data buffer, redo log buffer, shared pool, and large pool in Oracle database server ?
	7	How to investigate Process Global Area (PGA), background processes, control files, redo log files, alert log files, trace files, and database files of Oracle database server ?
	8	How to use performance evaluation tools such as UTLBSTAT, UTLESTAT, and Automatic Workload Repository (AWR) ?
	9	How to create, to manage, and to analyze tablespacees, how to analyze allocation of extents in tablespaces ?
	10	How to defragment persistent storage at tablespace level, at segment level, and at extent level ?
	11	How to measure and how to improve performance of database applications, how to choose the best index, how to analyze index structures ?
	12	How to use other types of indexes ?
	13	How to cluster relational tables ?
	14	How to create materialized views and partitioned relational tables ?

CSCI317 Database Performance Tuning
"How to ... ?" Cookbook
Experimented and "cooked" by Dr. Janusz R. Getta
School of Computing and Information Technology, University of Wollongong, Australia
Building. 3, room 210, phone +61 02 42214339
e-mails: jrg@uow.edu.au, Web: http://www.uow.edu.au/~jrg
Released on 18 June, 2023