#162. You queried the V$SYSTEM_EVENT view and noticed that there are waits for the “Log File Switch Completion” event. What could be the reason for these waits?
#163. In an effort to tune the OLTP database, you decide to increase the value set for the PGA_AGGREGATE_TARGET parameter. What could be the reason for this action?
#165. Jones and a couple of other users complain that their transactions on one of the application tables, TECH, are waiting for a response. On investigation, you find that one of the users, Smith, has not committed his transaction on the TECH table and he is not at his desk. What would you do to release the lock irrespective of the end result of Smith’s transaction?
gen. 0.101
Forum
Master braindump