Do you ever get that feeling that something just isn’t right, but you have no experience to go on and you’re just too busy to check up on it? I thought it was a bit strange that there wasn’t more communication between the RMOUG management and speakers, but it’s my first time as a presenter, so I decided I was being too high maintenance and didn’t follow up, just checking the site periodically for anything that may pertain to persenters. so this morning I noticed that I hadn’t received an email from someone in my Yahoo account and decided maybe…
-
-
I’ve found myself “whining” in the middle of an Oracle Freelist email conversations in regards to patching- or the actual need to patch. As a DBA, I have a love/hate relationship with patching. I love that if there is a bug in a version of Oracle, I can simply log into Metalink, (or My Oracle Support or MOS, what else are we calling it these days? :)) look up the error, verify with the documentation or with Oracle’s support and apply the patch- Yay me! Why am I hatin’ on the patch? My strong feelings are towards the CPU and PSU patching. …
-
I’ve decided it’s probably a good thing that blogspot doesn’t show the *exact* time I publish my posts… 🙂 I rarely write or publish anything before 10pm at night and have been saddened as I’ve become aware, (as I am a perfectionist at heart…) that I’ve made a couple mistakes in my blog. My ADD brain has either raced faster than my fingers could keep up on the keyboard, (meaning clarity of technical facts are just not there when I’ve read through a post later on) or I’ve edited an example script where the actual output wouldn’t have resulted in the error that…
-
I’ve come to realize that most folks don’t really understand the limitations in the allocation of PGA memory to hashing and sorting. They truly believe that if they set their PGA high enough, the database will just allocate as much memory as they have in the setting towards any hash or sort process, when in truth, (and I am referencing 10g here…) there is a “threshold” to protect the database from allocating too much PGA memory to any one process. This ceiling is for sorting or hashing and this is why I am such a strong advocate of viewing temp…
-
I’m preparing to build our new 11g environment and as I “study up” on all that is new in 11g, there are a few features that stand out over the rest, (at least in my book!) I/O Calibration I’m am challenging the upper most limits of my hardware with how much I/O I can produce. I have spent much of my time since I started with my new company correcting the I/O issues manually, (yes, ASM failed me, but I’m sure it will live up to my expectations someday!:)) The CALIBRATE_IO procedure that comes as part of the DBMS_RESOURCE_MANAGER packge…
-
After a lovely week off, I came back into work and brought up the OEM console to take a quick look at our databases. I noticed all our databases from one server were set to timing out on their uploads of the agent to grid control in the “All Targets” View. I logged onto the server and attemped to upload them manually: From the $AGENT_HOME- emctl upload agent; I received the following message: ERROR-400Data will be rejected for upload from agent ‘https://:/emd/main/’, max size limit for direct load exceeded [6827354/5242880] This error is due to a file limit on the…