Oracle Archive

Presenting on UKOUG 2006

All 3 abstracts I sent were selected to be presented at UKOUG 2006! All of them on 14-AUG - tough day!

Extending Oracle 10g Grid Control - New Metrics, Targets and Plugins

Oracle 10g Change Tracking Inside Out
Refreshing Test Databases Using Oracle Transportable Tablespaces and Veritas Storage Checkpoints

It’s going to be the first time I present to [...]

I was looking on the grid computing syndrome and to my surprise Google Trends “Grid Computing” shows that hype around it was actually going down since 2004:

Interesting that the Oracle Grid Index shows continuous growth:

I can only think of some possible reasons for this deviation:

People are moving from talking about it to really doing it.
Oracle [...]

The second issue of  Carnival of the Vanities for DBAs is out! Oracle July CPU topic was only on the third place whereas I expected it to be on the top… Still pretty close.
I like very much that idea and hope that I’ll be able to contribute to this interesting project… since [...]

Oracle histograms are often treated as devil of CBO as they cause bind variable peeking which is most of the times leads to quite nasty surprises when no one expects them. Common approach to avoid bind variable peeking is to remove histogram collection. However, it’s not true at all. Bind variable peeking can happen even [...]

Yesterday, I took a part in a meeting with one on Oracle product managers in security. Spoke about few technologies and Audit Vault looked quite attractive. On the other hand it’s nothing but a data warehouse that can load data from various sources including Oracle database, iAS and 3rd party tools. So if I can [...]

Solaris ZFS

James Foronda posted a nice note about ZFS. His primary topic was silent data corruptions but the presentation he mentioned is quite a good overview (though, smells a bit of marketing but who knows - maybe it’s all true?). In my previous post I mentioned that I am installing RAC on Solaris under VMware - [...]

Big news - I’ve got an exciting opportunity in Ottawa, Canada and finaly we decided to move. Quite a change as we were thinking for few years already to move to… Sydney! So quite an opposite place in the end with rather opposite climate. Once again I can see that my family is the [...]

Oracle CRS 10.1 didn’t provide any straightforward way to change to change a single property of a resource. Assume you need to change check interval of a VIP resource from standard 60 seconds to 10 seconds. The steps are below.

Create .cap file with properties – “crs_stat -p ora.node1.vip >/tmp/ora.node1.vip.cap”
Edit /tmp/ora.node1.vip.cap to change line CHECK_INTERVAL=10
Load .cap [...]

“Are you missing your favorite scripts and indicators in Oracle Enterprise Manager Grid Control? Find out how easy it is to incorporate your own metrics into the Grid Control framework. Do you manage a multiple vendors’ environment and need to monitor many different components? Learn how to create your own completely new target types in [...]

UKOUG Abstracts

I was reviewing abstracts for UKOUG conference 2006 and saw a lot of very good ones! I sent couple abstract myself but I am afraid that next to the famous speakers there mines would look faded. At least, I would understand if none of my presentations “make it to the finals”.
Well, Russians didn’t make it [...]