by Derek Nerenberg | Jul 12, 2013 | Blog, Databases, Enterprise Java, Portals
Set the transaction isolation level to READ_COMMITTED with READ_COMMITTED_SNAPSHOT turned ON. Yay! When I mention the words “transaction isolation level” to SQL Server DBAs, the first words out of their mouths are almost always “READ...
by Doug Groves | Jul 10, 2013 | Blog, Databases
Ran into an interesting situation recently with a managed services client running Oracle 11.1.0.7.0 Enterprise Edition on Linux in a two node RAC environment with Dataguard. The client asked to have the dataguard instance changed over to read/write to do some testing....
by Brad Patterson | Jul 1, 2013 | Blog, Databases
In the past, using a client-server architecture with IBM Informix database software required adding an entry on the database server with the client details, either in a .rhosts file in a specific user directory or the/etc/hosts.equiv file. If one of these was not...
by XTIVIA | Jun 26, 2013 | Blog, Databases
At XTIVIA, we often perform health checks and performance tuning for clients that have issues with the CPU utilization or memory usage periodically maxing out in the middle of production by the execution of a job or report that consumes much of the available resources...
by XTIVIA | May 24, 2013 | Blog, Data Management, Databases
A couple a days ago we had a client contact us and ask us to take a look as their Oracle Cloud Control 12c. They were having issues with a few targets that were reporting as being down on one screen and up on another. We logged into the server and tried to run ./emctl...
by XTIVIA | May 16, 2013 | Blog, Databases
One of our Virtual-DBA clients has a small DB2 environment with version 9.7 on Linux and HADR connecting a primary and standby system. When the application team created the database, it was created using Automatic Storage on the /home filesystem. This will...
by XTIVIA | May 13, 2013 | Blog, Data Management, Databases
We have a Virtual-DBA client that was rapidly running out of space for one of their databases in VMWare. To rectify the problem we decided to move a few tablespaces to a new LUN/disk presented to the VMWare OS. We had a scheduled downtime window so we didn’t need to...
by XTIVIA | May 13, 2013 | Blog, Data Management, Databases
This Saturday we were scheduled to patch eight oracle 11gR2 databases with the latest CPU/SPU set for one of our Virtual-DBA clients. The databases were running in a zone on Solaris 10. This is normally a pretty straight forward process, but this weekend we ran into...
by XTIVIA | May 7, 2013 | Blog, Data Management, Databases
So today we had a Virtual-DBA client ask us to help them patch their Oracle Financials R12 for a bug they were having a problem with. So I thought I would share with you the process we used to patch their server. They had sent me the patch number that Oracle support...
by XTIVIA | Apr 25, 2013 | Blog, Databases
Many of our Virtual-DBA clients have DB2 upgrade plans in the works. One of them wants to move from V9.1 to V10.1 on Windows. I’ll share some of my experience with this project. Right now I’ve completed the set up of the 10.1 instance and...
