In this article I will discuss some SQL tuning guidelines that are simple but effective. SQL is the heart of the Oracle system. You can use many different SQL statements to attain the same result. It is often the case that only one statement will be the most efficient option in a given state of a ...
我们经常碰到操作系统在大量的使用swap,根本原因是物理内存被大量使用。 我们就有必要确认哪些进程在大量的使用内存,使用了多少,然后再进一步去挖掘这个进程的具体操作。 We used the Unix ps command to get a listing on the operating system side and then looked inside Oracle to view these same processe ...
To understand Oracle background processes is to understand how Oracle works--offering opportunity to tune effectively. With every version comes the potential for additional background processes when an Oracle instance is started. If memory serves me right, back in Oracle 7 there were onl ...