working on applications and technology

Recently I ' m working for a customer for a Oracle Database migration project from Sun Solaris to HP-UX platform. It  is a 10.2.0.4 RAC with totally 3.5 terabyte datafiles which reside on a Symentec cluster file system.  The migration requirement is simple: minimize the downtime of the database and keep it simple.

I consider all the possible solution for database migration across platform:

 Read more

As we mentioned in the last article that with Oracle 10g,  Oracle introduce the concept of 'Metric' and 'Baseline' for pro-active database performance management. It is a big leap for effective performance managment.

What is Metric

For the versions before Oracle database 10g,  The main performance diagnostic tools is statspack.  The essence of stackpack is to compute the change for Oracle internal counters:Read more

Recently I re-read the performance document of Oracle Database 9i,10g and 11g.  It is interesting to notice that different performance tools available with different version of Oracle database.  The newer version always introduce some new concept that lead to new performance tuning methodology.

This evolution of performance methodology could be best descrbied with the following:Read more

After building our essbase analytic model and importing the data, the next big thing is to keep our essbase data refreshed with each coming day's new data . And it might be necessary to  add  new dimension member to the outline sometimes (e.g. we might have to add today's date to the date dimension before loading today 's sales data)Read more

A few days ago, a friend complaint that he could no understand some word when he spoke with the customer, cause this customer is a Siebel user and use some kind of  'siebel language' that he could not understand! and he turn to me for help.

What is Siebel Applications ?

This  question is not so difficult to understand actually. Of cause we all know about the fact that Siebel is a famous CRM(Customer Relationship Management) system that we use to manage our customer, our partners and our own staff and link them together.Read more

In Essbase we could tag a dimension either 'dense dimension' or 'sparse dimension'. The definition of dense dimension is that the account dimension value must exist for almost every 'dense dimension' member. While for sparse dimension, there shouldn't be many value for 'sparse dimension' member.

Well this is easy to understand but you will not fully understand these two concept unless you 'r aware of how essbase use different storage machenism for these two dimension type.

It is all about storage efficiency!Read more