by XTIVIA | Feb 20, 2013 | Blog, Data Management, Databases
We had a Virtual-DBA customer request that we install and configure a new Grid Control agent on a new server with existing databases. While there are several ways to do this, we wanted the customer to be able to perform this task by themselves in the future. The...
by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence
Absolutely! The reports from Gartner are great (at least from my perspective) and there is a lot of useful information in them. I found the latest one particularly engaging. As I read through the report, I started thinking about what it means to us (as practitioners...
by XTIVIA | Feb 11, 2013 | Blog, Data Management, Databases
Encountering the ORA-01502 error due to unusable indexes in Oracle can be challenging. A client called with an issue running a script from a 3rd party vendor. He was getting Oracle error ORA-01502 while running the supplied script. The ORA-01502 is basically stating...
by XTIVIA | Jan 22, 2013 | Blog, Data Management, Databases
The other day our monitoring system had thrown a couple of alerts for a client. It was reporting there were errors in the client’s alertlog. I logged in and checked the alertlog and sure enough there were multiple dreadred ORA-00600 errors being reported in the...
by Kathleen Long | Jan 4, 2013 | Blog, Data Management, Databases
Every database holds different business data and has its own recovery needs. Unfortunately, there is not a single solution for all databases. There are many possibilities and solutions. For each database you are responsible for supporting you should be asking...
by Kathleen Long | Dec 20, 2012 | Blog, Data Management, Databases
This feature in the maintenance plans in SQL Server seems to be either ignored or over used. Either people do not put this step into any maintenance plan causing MSDB database to grow large over time. Or they have this step placed in every maintenance plan not fully...
by Kathleen Long | Dec 19, 2012 | Blog, Data Management, Databases
An interesting request came in the other day, is there a way to tell how much memory each database is using on an instance. You can always use properties to see how much memory is allocated to the SQL Server and there are performance counters available to track how...
by XTIVIA | Dec 12, 2012 | Blog, Data Management, Databases
Recently I received a call concerning failing backup jobs being taken via Expdp. I logged in to our Virtual-DBA client’s site and immediately checked the alertlog for errors. The below errors were found in the alertlog. Exporting orcl on DBHOST01 Sun Dec 16...