***Please read the entire post if you are looking for a fast way to compare two lists*** If you need to compare two lists, you can use a list comprehension such as the following: 1 2 3 4 5 >>> a=[1,3,5] >>> b=[1,2,3,4,5,6] >>> print [c for c in b if c not in... »
Archive for October, 2010
Generating chargeback costs using AWR
Monday, October 18th, 2010
One of the best things about AWR is the fact that it tracks CPU at a database service level. This allows us to calculate the amount of CPU used by a service in any number of ways. Once you can gain agreement with the business on the most accurate way to determine the CPU... »
Careful with that append hint!!
Thursday, October 14th, 2010
Today a DBA issued an insert statement with an append hint. This resulted in a fairly time consuming insert of many rows. The DBA was puzzled when all other sessions were blocked from inserting into the table. This is actually fairly easily explained. An append hint instructs Oracle to take out a TM lock... »
Fined grained dependency – Down with select *!!!
Tuesday, October 5th, 2010
In 11G, I would like to suggest that you begin to move away from select * in your PL/SQL views and hardcoded procedure/function cursors. The reason I suggest this is that versions 11.1.0.6 and higher support “fine grained” dependency checking. What this means is that unless you use a column in a table in... »