Voodoo吗? 了解如何执行Oracle跟踪.您的DBA应该会提供帮助.

Voodoo ? Find out how to perform Oracle tracing. Your DBA should help.

使用跟踪文件，您可以查看Oracle的等待事件.这将告诉您性能非常糟糕"时数据库正在做什么.它可能正在等待锁，可能正在读取表....

With a trace file, you can look at Oracle's wait events. This will tell you what the database was doing when 'performance is atrocious'. It could be waiting on a lock, it could be reading a table....

一旦您知道为什么它很慢，解决方案通常就会变得显而易见.

Once you know why it is slow, the solution often becomes obvious.

我推荐此

I recommend this whitepaper as an instruction to developers on working with databases.