(Hemant K Chitale) We use the METHOD_OPT parameter to specify columns where we want specific Histograms when running a GATHER_TABLE_STATS. Oracle can actually make use of an Index to gather such column statistics.
Other News
Dimensional modeling with IBM InfoSphere Data Architect, Part 1: Forward engineering in InfoSphere Data Architect
(Yun Feng Bai and Prabhudoss Samuel) IBM InfoSphere Data Architect (IDA) is a collaborative data design solution that helps you discover, model, relate, and standardize diverse and distributed data assets. It is a pivotal component of the IBM initiative to enable an integrated data management enviro
Backwards Compatible Reports for SSRS
SelecTViews With Stephen Wynkoop Check Out SelecTViews to hear about a new Heavy Lifting Database Engine called UnQL from CouchBase. Backwards Compatible Reports for SSRS Yesterday I introduced an issue one of our reader faces by having to support older versions of SQL Server Reporting Services, while taking advantages of the new features of the current release. I didn’t receive […]
SelecTViews – News about the Dell Cloud announcement at VMworld 2011, the Nokia SQL-injection attack and more.
Video Programming for IT Professionals
Backwards Compatible
Backwards Compatible The following question was posted in the SSWUG group on Linked-In: “How we do deploy a RDL developed using Visual Studio 2008 environment in SQL Server 2005 Reporting server?” This is really a very good question. It is worthy of some discussion should you, our reader, have time to respond with your ideas and experience. The issue for […]
Code Contracts Settings in Visual Studio 2010
(Dino Esposito) Last month I introduced software contracts as they’re implemented in the Microsoft .NET Framework 4. Known as Code Contracts, software contracts allow you to express formal conditions your code should fulfill to work properly.
What are the Security Attributes?
(Sanjit Anand) Securing attributes are used by some Oracle HTML-based applications to allow rows (records) of data to be visible to specified users or responsibilities based on the specific data (attribute values) contained in the row.
Terminating Parallel Loops
The fourth part of the Parallel Programming in .NET tutorial looks at the early termination of parallel loops. Unlike sequential loops, which can be exited with the break command, there are considerations when stopping loops that run on multiple cores.
CRS-4046: Invalid Oracle Clusterware configuration. – 11gR2
(Anand) After failed installation of 11gR2 Clusterware (due to wrong cluster_interconnect IP), during the second attempt, i received the below error while running the “root.sh” script on the first node.
Very Large Migrations
(Dermot O’Neill) Most of the time SQL Developer does a good job of migrating a database from SQL Server, Sybase ,… To Oracle. But there are some tricks to help make very large migrations perform smoother.