Badges

55 Points
11 Years

User Activity

Over 6 years ago
Isn't SPARC now an obsolete piece of hardware within Oracle?
About 8 years ago
With regards to "Ability to migrate a database to Exadata from a normal environment" in Room for Improvement What did you try? I found a simple CTAS worked just fine. The Transportable TS and GoldenGate were just too much trouble setting up. Going from AIX to Linux also was…
About 8 years ago
Hi Primary interest is in Business Models (Function and Data). Also like to design and develop solutions on the Oracle platform but am not wild about the various certifications being demanded. The setup or the hardware is usually a one time effort and nobody will know the…
Almost 9 years ago
Arup -- I agree don't go too wild applies to anything. However, people read these things about Exadata and go wild OR just do nothing so as to keep everything the same. And not many people talk about Oracle Text Indexes and how different the behaviour Also in your "travels…
Almost 9 years ago
Don't go too wild with dropping indexes. You do need those that are for data integrity and for standard OLTP. In our first tests with Exadata X2, we did try dropping all indexes. We did not get any through put for the ETL Also to get any benefit from the Index Cell Storage,…
Almost 9 years ago
You mention each results. What score is an acceptable value for the initial setup? Is the initial setup accepted because the database starts? We had a situation where nothing from the companion disk was installed and so important features of Oracle Text were not available…
Almost 9 years ago
Post 2012 if the Exadata is not set for GATHER_SYSTEM_STATS('EXADATA') a lot of the benefits will not show up. You will then remain in the '2x to 3x' club of Exadata performance instead of the potential 15x performance. -- quoting Mark Smith at Database Specialists -- in…
About 9 years ago
Have been finding that in some situations with partitioned tables ignoring the local index (partition key) and doing a full table scan is a lot faster! For example select /*+ parallel(t1,8) */ column_x from partition_table t1 where partition_key_column >= trunc(sysdate-30)…
Over 9 years ago
We have a script which monitors space left based on what the user_segments reports as used. We have also started to use bigfIle tablespaces.
Over 9 years ago
Daily incremental backup. The goal is to have dataguard.
Almost 10 years ago
Data Warehouse is an attempt to correct the poor database designs in which the transactional data resides. So a DW is an "after the horse has escaped the barn" solution attempt. The more horses that have escaped, and it may not even be certain how many horses, the more…

Answers

Comments

Over 9 years ago
Relational Databases Tools

About me

 Passionately believe that Information Technology provides the best opportunity to improve the competitive advantage be it from reduced operating costs, improved communications, better and consistent information, reliable and accurate source of data or improving research and fostering growth in knowledge.

 Strong belief that IT deployment must address identified gaps in meeting mandated business capability. A business model addressing information requirements and data acquisition needs is a pre-requisite to success in deploying IT solutions.

 Successful at formulating Information Technology Strategy and developing Business Function and Information Models to drive the deployment of applications to support business goals.

 Keen understanding of developments and advances in deployment of Information Technology and practical experience in setting up data centre with both desktop and mobile access, disaster recovery and high availability environments.

 High awareness for compliance to the regulatory process for financial data integrity among separate applications and data downloaded for special reporting tools.

 Create innovative solutions to meet business goals by taking advantage of standards and applying knowledge from past projects in the design/development/deployment of Custom Applications, ERP Packages, Business Intelligence, Regulation and Compliance in Drugs and Health Care.

 Understand that good quality data is a pre-requisite for Business Intelligence

 Written and Presented Papers at International Conferences on Information Technology Framework, Business Modelling, Data Warehouse Design and Customizations to Packaged ERP products.

 Proven record of custom software development using Software Development Life Cycle for both the Waterfall and the Prototype approaches.

 Experience working in Federal and Provincial Government departments, Private Sector and Non-Profit organizations.