(Hemant K Chitale) After the curious finding in my previous blog post, where a Partition’s HighWaterMark was noticeably higher than that for a non-Partitioned Table but then shrunk on a MOVE operation, retrying the same rows with a different pattern of INSERT statements.
Tag: Oracle
Gold Agent Image
(Kellyn Pot’Vin-Gorman) The Gold Agent Image is going to simplify agent management in EM13c, something a lot of folks are going to appreciate.
SystemTap Guru Mode and Oracle SQL Parsing
(Luca Canali) SystemTap and dynamic tracing tools in general give administrators great control on their systems with the relatively little additional effort to learn the new tools. In this post you will see how SystemTap that can be used to modify data on the fly at runtime.
Are your SQL Plus scripts going to ‘ell ?
(connormcdonald) Excuse the hideous pun in the title. All will become clear shortly.
OMS Upgrade Fails At Repository Configuration With Error ORA-20251
(Gokhan Atil) Yesterday, one of my blog readers asked me how I didn’t encounter ORA-20251 error when upgrading my EM12c to EM13c. He also pointed My Oracle Support document (Doc ID 2095025.1). The document says a new record will be inserted into EM_COST_CENTERS table (in fact the table name is EM_CO
Another SQL Profile to the rescue!
(Bobby Durrett) We have had problems with set of databases over the past few weeks. Our team does not support these databases, but my director asked me to help. These are 11.2.0.1 Windows 64 bit Oracle databases running on Windows 2008.
Force OEM to Discover HA Systems
(raysmithace) You know there’s a cluster and that means that an HA system exists, but OEM won’t discover it. Of course that means that your RAC databases can’t be discovered either and all of this is making you cranky. Take a deep breath. We can fix this.
Up to date text indexes
(connormcdonald) If you really need your text indexes to be “super dooper” up to date, that is, always in sync with your data, you can set the SYNC level to be ON COMMIT.
Compressing your Indexes: Advanced Index Compression (PART 2)
(Vineet Marwah) As we discussed in the Part 1 of this blog series, index entries with many duplicate keys (or duplicate prefix columns in the index keys) can be compressed making it possible to reduce both the storage overhead and the access overhead for large index range scans or fast full scans.
Monitor CPU Usage Information
(Mir Sayeed Hassan) This script will monitor CPU Usage Information.
