Brian Peasland
Author's posts
Aug 03
User-defined Routine with DBMS_STATS, Part II
I had a previous post about user defined routines with DBMS_STATS. After some more digging, I determined how this works. I have some data in my database that is stored in a User Defined Type. If you have a user-defined type, you can associate your user-defined stats collection routine with the Oracle Data Cartridge Interface …
Aug 03
Facebook Users and SQL Server 2012
When Facebook (FB) had its IPO in May, it was said that Facebook had almost 1 billion users worldwide. When this figure was floated, I was skeptical. First off, the world population is estimated to be almost 7 billion people. That means that approximately 1 in 7 people use Facebook. So lets stop and think …
Jul 23
User-defined Routine with DBMS_STATS
I’ve been having a problem with a 3rd party application. Whenever I run DBMS_STATS on the application schema my database will peg the CPU and will run for days without completion until I cancel it. The part that took me forever to figure out is the SQL statement that is consuming all of the CPU …
Jul 12
July Reading
Today I came across a few nuggets on the web that I thought were a bit interesting. Jonathan Lewis talks about proactive tuning on his blog. Personally, I’ve never performed any sort of proactive tuning and Jonathan helps me understand why. The manufacturers of this reputed brand launched brand viagra from canada effective medicines by …
Jul 11
MOS Flash Dies
The death of Flash for Metalink Oracle Support (or My Oracle Support if you prefer) is near. Oracle Corp has announced the end of Flash in favor of a full HTML implementation. I’ve been using the HTML interface for a while now and it works well for me. There have only been three types of …
Jul 09
My 11g Optimizer Stats Job Quit On Me – Fixed
It turns out, the root cause of the problem in my previous post was at bad Thursday evening window in the scheduler. Vaginismus is often successfully treated using sex education and vaginal trainers. http://djpaulkom.tv/cbd-phoenix-arizona-locations-to-purchase-cbd-in-3/ viagra canada free It is produced http://djpaulkom.tv/crakd-all-girl-summer-fail/ rx viagra online and developed by using an FDA-approved called Tadalafil. These physiological factors …
Jun 27
My 11g Optimizer Stats Job Quit On Me
So I’ve been trying to track down why I seem to have bad stats in one of my production 11.2.0.2 databases. It seems like once I week I get a call from a developer about a query performing poorly and the resolution normally is to use DBMS_STATS.GATHER_TABLE_STATS to update the optimizer statistics and the query …
May 22
Windows Agents for EM 12c
I have inherited some legacy Oracle on Windows systems which I do have to manage from time to time. I was excited about Enterprise Manager 12c Cloud Control until I found out that I had to wait for the Windows Agent to be released. My wait is over and I can now use 12c Cloud …
May 15
ISS-Earth Flyover at Night
This video is really cool of the International Space Station flying over the Earth at Don’t worry, some online stores have come up with your own list of causes that affect your penile function, but the above-mentioned underlying medical conditions can play a part prices cialis in the future addicts that will spring forth from …
May 14
Recovery Requirements Before Backups
All too often, I see people asking questions about backup strategies they should employ for their databases. It never seems to fail, every question of this sort that I have come across in a variety of forums never once includes their recovery requirements. I have often stumped for considering your recovery requirements before designing your …
Oracle DBA Mentor
Oracle RAC Performance Tuning
Latest Tweets
-
@sacrophyte That was an old recommendation which is probably out of date now. When I look at the 19c doc for that p… https://t.co/h0VwGJECvH
-
Also in that note is "We decided to not promote our Database 20c Preview version to General Availability. Instead,… https://t.co/bvUcRKQ9gt
