We have just migrated a database to a new server that has two dual-core CPUs. We are noticing that Oracle seems to max out at 25% of the total CPU power on the machine, even when it is running highly compute intensive processes that would max out the CPUs on our prior machine. The new server is Windows 2008 64-bit and the old server was Windows 2003 64-bit. Is there any setting in Oracle or the Operating System that would be limiting the CPU usage for Oracle? It does run on all four CPUs (CPU affinity) but the total usage does not exceed 25%.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
When experiencing some peculiar problem with the functioning of your PC, how many times has it happened that you look for a solution and even google can’t help?
It could be that you are one of the only few people on earth who ma…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…