Name a few places you will look to get more details on a performance issue.

Oracle records the information about different kind of errors and the processes in the files, such as ALERT log, user process trace files, and background process trace files.