While working on a customer project, I needed to retrieve SQL Server SCOM Management Pack version.
Unfortunately, SCOM team took a while to answer and as I am the DBA, I have access to SCOM’s databases. So let’s seek how we can get this the hard way.
While 8k is the default block size, Oracle supports other block sizes, too. Smaller block sizes (more commonly, 4k) are encouraged for OLTP workloads to reduce concurrency, and even smaller block size, 2k, is recommended for databases running on “Advanced format” (or “4K”) storage. Oracle documentation warns us of possible implications when storing larger rows in 2k/4k blocks, such as potentially larger space overhead due to metadata, or even possibility of row chaining.
It’s funny how you can make little savings in work all over the place in Oracle if you’re prepared to look a little closely at what’s going on. Here’s a quirky little example with LOBs and function calls that might just have some greater relevance in other situations. Here’s a little data set, and two queries that I might run against it:
We (Gorcan, Glen, Debra and I) arrived into Mexico around 10pm and had a few minutes wait for our local user group contact to meet us. They had arranged transportation to our hotel.
Register by clicking here.
Hope you'll join me!
I had a problem with an Oracle 126.96.36.199.0 database producing trace files every few minutes.
I just need the info after Area=. so in this case CapitalMetro.