Database App Development, Management and Performance

In my years as an Oracle and SQL Server DBA and the many technical environments I’ve worked in, there’s almost always one database in each place that is a hybrid of OLTP and OLAP.  A highly transactional database that also has reporting requirements, but no separate reporting database.  This type of database is pretty much a guaranteed challenge for any DBA.   On one hand, [...]

Sigh….IF I could only live in “Uncle Larry’s” perfect database world where I have more control over what choices are made from the conception of the database’s life and know exactly what goals a development group has vs. Oracle.How much easier a DBA’s life would be if we could just say, “Sorry, Oracle’s new feature [...]

I’ve started working on my abstract to submit for RMOUG 2011.  I want to present on some of the CBO challenges I’ve taken on in the last year with large data sets.   There are a number of tricks that could be very useful to others in how to manipulate the CBO to work with tables over 100G [...]

A little off technical topic and (hopefully) in good humor, I want to talk about DBA crushes.  Most techies have them, but as a female DBA, I can refer to them as “crushes” without anyone taking too much offense to the term, (hey, I’m after these guys for their technically brilliant minds, mind you!)   I’m [...]

Oblivious as I am at times, just realized how difficult it might be for anyone looking for my RMOUG presentation and white paper! Here’s the links to my uploaded docs, instead of just having them in comments in a post! http://docs.google.com/fileview?id=0B8JpTBjeGkOsMzk1NzBjYjAtOWE5ZS00ZGMzLWFkMDMtMDExNDI4ZjgzZWI5&hl=en http://docs.google.com/fileview?id=0B8JpTBjeGkOsN2RmYTcyNWMtMjkzZi00MTQ2LTk1NWUtMzg0MDAzZjgyMjRk&hl=en Thanks,Kellyn

Problem Description Oracle Grid Infrastructure, Oracle software Installation went successfully and so creation of oracle database. After installation it is checked CRS daemon on both domains and it is shown all services are online like below. # crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster [...]

Very cool article, outlining some common & simple screen design patterns – for both web and desktop applications.  Be sure to check out the 2010 Update as well. I always tell students in our training classes that they should not try to re-invent the design patterns used in most applications – especially since they are [...]

As you may know, OBIEE 11g was released not too long ago. I downloaded it the day it was available, and have been trying every since to 1, find the time to install it and 2, not break the install process. EnvironmentGuest: Windows XP Professional (an old image I had lying around)VirtualBox 3.2.8Host: Ubuntu Karmic [...]

If you’re interested in a very cool app from Google, check out Google Goggles!  This app allows you to take a picture of about anything and it finds the item so you can get more information or purchase the item.  In fact, you can barcodes for an app and it pops right up in the market!  [...]

I’ve continued to work on my Android App library in my spare time.  I’ve been very happy with the results so far.  None of my apps are “killer apps” yet.  On average each app sells about 1 copy a day.  In other words, my revenue is about $150 per day.  Some apps haven’t sold a [...]