by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence, Data Warehousing
Lately, we at XTIVIA have seen a marked uptick for interest in open source ETL tools. Each customer situation is unique, but I would like to propose a few factors that you should review before making the decision: Incumbent Tool Set: Decisions around your choice...
by XTIVIA | Feb 13, 2013 | Blog, Databases
Introduction A question we are often asked by both our Virtual-DBA and Consulting customers is: Why do I have to update statistics if auto-update statistics is turned on? The short answer is that your data changes, and even if you have auto-update statistics...
by XTIVIA | Feb 12, 2013 | Blog, Databases
Started: 1:03:12 PM Progress: 2012-02-08 13:03:15.24 Source: Data Flow Task Validating: 0% complete End Progress Error: 2012-02-08 13:03:16.15 Code: 0xC0047062 Source: Data Flow Task V91MOD APIMAG [1] Description: System.Data.Odbc.OdbcException: ERROR [IM002]...
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 | Feb 11, 2013 | Blog, Business Intelligence, Portals
Customer: “When will you deliver the scope in our statement of work?” Consultant: “We are Agile, so we can’t tell you that!” Customer: “At least give me a high-level timeline. When can I expect to see my deliverables?”...
by XTIVIA | Feb 10, 2013 | Blog, Business Intelligence, Databases, Portals
A very large gift given to us user interface developers in Liferay 6.1 is the inclusion of SASS support. One of the many ways SASS comes in handy is handling prefixed CSS rules – instead of having to specify each rule every time you, say, want to declare a gradient,...
by XTIVIA | Feb 6, 2013 | Blog, Data Warehousing, Databases
We all worry about the performance of our servers. It is what separates the DBAs from the pretenders. You just never know just what setting will be the one that makes the big difference. The worst part is that the setting that works today may hinder or not even...
by XTIVIA | Feb 5, 2013 | Blog, Databases
Recently we migrated one of our client’s SQL Server instances to a new server. During the migration we had moved the storage to the new server so the old server didn’t have some of the disk drives that were previously mounted on it. After the migration the...
by Doug Groves | Feb 1, 2013 | Blog, Databases
I recently came across an issue in a 2 node RAC, Oracle 11gR2 environment for one of our Virtual-DBA clients. The client dba had created a new spfile and placed it in ASM for node 1 and then tried to restart the instance using srvctl. The instance...
by XTIVIA | Jan 31, 2013 | Blog, Databases
Msg 1205, Level 13, State 68, Line 10 Transaction (Process ID 79) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Msg 5069, Level 16, State 1, Line 10 ALTER DATABASE statement...
by XTIVIA | Jan 28, 2013 | Blog, Databases
Have you ever had a situation where Oracle database software or services have not been uninstalled properly or completely on a Windows OS? Well this happens more often that we would like. The options left to us at this point are either painstaking editing of the OS...
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...
