Watch as Steven explains what he means by hard-coding in PL/SQL.
That's right. VARCHAR2 declarations mean that you have to provide an "N" or constraint on the size of the variable. If you have such declarations all over your code, that's a form of hard-coding and you are likely to get hammered by VALUE_ERROR exceptions. This video shows how to fix this problem.
Since we write software using our brains, it is hard to avoid the impact of psychology and physiology of our brains on our code. This manifests quite clearly when it comes to hard-coding.
For DBAs looking to streamline the process of cloning a database for development and test efforts, the Oracle Snap Management Utility (SMU) for Oracle Database may help solve that need. The SMU software coordinates storage cloning from the Oracle ZFS Storage Appliance with the process to mount the new clone to a database host from a single interface. Take cloning for development databases from weeks to minutes and accelerate dev/test with SMU. Scott Ledbetter, Oracle Application Integration Engineer, shows how to easily clone an Oracle database instance using the Oracle Snap Manager Utility for Oracle Database. To learn more and obtain a free trial, go to http://oracle.com/storage/nas/snap/in....
The Trace File Analyzer (TFA) Collector Tool is a utility for collecting first failure diagnostics when creating Service Requests with Oracle Support. Using TFA Collector to make diagnostic collections removes questions about what files to collect and upload. TFA knows about all the well known Oracle and operating system diagnostic locations and collects only files that have been modified proximate to problem time specified from any of those well known locations. Larger files are also pruned proximate to problem time specified to reduce the size of the upload. If the system is a clustered environment TFA collects relevant diagnostics from the remote nodes as well. All of this can be accomplished with one simple command.
Key features of TFA Collector include:
Some extraordinary claims have been made about what Exadata can do for consolidation, can they really be true? There are good technical explanations for these claims backed up by extended testing and customer experience. This seminar looks at the consolidation densities achieved, ease of operations and some practical limitations. We'll also look at how Exadata is applicable through the whole life-cycle from Development to Production.
Watch this brief product overview for Oracle Database security.
Information is key to the success of most organisations today and as such the more information you have about your customers the better business decisions you can make. T his means that databases (which hold the information) continue to grow in size and additional storage needs to be purchased on a regular basis to meet this growth. In this webcast we'll look at how Storage Optimization techniques can be used to reduce the Oracle database footprint and avoid the cost of new storage and/or reclaim some of that storage for use by other systems. We'll also take a look at some of the tools available to help you understand the likely benefit you will see from this reduced footprint and how we can work with you to look at the cost justification.
This demonstration shows you how to discover the components of an Oracle Exadata Database Machine.