In the Oracle Linux 7: Advanced Administration course, you will learn how to configure network services and authentication services, implement virtualization technologies to more effectively manage system resources, perform advanced storage administration tasks, implement shared storage technologies, and develop advanced troubleshooting skills.
Learn to increase Oracle Database performance and improve user response time by deploying Oracle's Flash Accelerator hardware with Oracle's Database Smart Flash Cache feature
Learn about best practices for OCFS2, a high performance, HA, POSIX compliant general-purpose file system for Linux. OCFS2 is fully integrated in mainline linux kernel and is embedded in Oracle VM and can be used Oracle Database and Oracle RAC solutions.
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....
This self study course looks at the hardware and software components contained in the Oracle Database Appliance. It covers the Oracle Database Appliance Configurator, racking and cabling, and database deployment and patching.
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.
In this tutorial, you create a simple XMLType table named PURCHASEORDER using the default settings, and then load 10,000 XML documents into the PURCHASEORDER table. You also use XQuery Full Text to search XML documents. In order to use XQuery Full Text, you must create an XML-aware full-text index on the documents that you want to search.