Badges
55 Points
11 Years
User Activity
About 7 years ago
Answered a question: Do general purpose or OLTP Oracle databases really perform better on SPARC based servers?
Isn't SPARC now an obsolete piece of hardware within Oracle?
Over 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…
Over 8 years ago
Commented on IT Central Station Elite Squad
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…
Over 9 years ago
Does not Oracle Support also have an ExaChk utility? or is that Enkitec only?
Over 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…
Over 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,…
Over 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…
Over 9 years ago
Commented on Exadata can significantly improve performance but there's a learning curve in a few key areas.
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…
Almost 10 years ago
Commented on v1 and v2 on Linux: Its large memory capability and parallelism potential has given a big boost
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)…
About 10 years ago
Commented on Beware: Need to monitor disk space
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.
About 10 years ago
Commented on v1 and v2 on Linux: Its large memory capability and parallelism potential has given a big boost
Daily incremental backup. The goal is to have dataguard.
Over 10 years ago
Answered a question: At what point does a business typically invest in building a data warehouse?
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
About 7 years ago
Relational Databases Tools
Over 10 years ago
Data Warehouse
Comments
Over 8 years ago
Over 9 years ago
Data Warehouse
Almost 10 years ago
Data Warehouse
About 10 years ago
Data Warehouse
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.