(Craig Shallahamer) As I wrote in the first part of this series, forecasting Oracle performance is absolutely essential for every DBA to understand and perform. When performance begins to degrade, it’s the DBA who hears about it, and it’s the DBA who’s supposed to fix it. Fortunately, low precision
Tag: Oracle
Oracle BPEL Process Manager (Sample Chapter)
In this chapter we will take a detailed look at the Oracle BPEL Process Manager Version 2.0, a BPEL server that enables us to deploy and run business processes defined in BPEL. Oracle BPEL Process Manager is developed in Java and runs on a J2EE application server. In addition to deploying and ru
Row-Level Security with Virtual Private Database
(David C. Knox) For many years, Oracle’s customers repeatedly asked for a logical and elegant method for applying security policies to the data within database tables. And for many years, Oracle responded by saying, “Use views with functions.” As Chapter 10 illustrates, in many circumstances thi
Working with LOBs in Oracle and PHP
(Harry Fuecks) Working with Oracle types like VARCHAR2 is fine, but what if you need to be able to store more than its 4,000-byte limit in one go? For this task, you need one of Oracle’s Long Object (LOB) types, which in turn requires that you learn how to use the PHP API for working with LOBs. That
Exploit circulating for newly patched Oracle bug
(Robert McMillan) Database administrators now have an added incentive to install Oracle Corp.’s latest security patches, which were released earlier this week. Malicious software is circulating that can crash an unpatched database server, and one security expert predicted that more malware targeting
Binding Variables in Oracle and PHP
(Larry Ullman) As you are certainly aware, the majority of today’s Web sites rely upon databases in one way or another. Whether the site you are building requires a forum, an e-commerce component, contains tons of articles and information, or just takes feedback from visitors, you’ll probably incorp
Oracle Tip: The wrap utility and code obfuscation
(Scott Stephens) Oracle PL/SQL is loaded into the database in one of two ways. The primary way is to apply the PL/SQL code against the database directly in a SQL script from source code. But, if you’re shipping the code to an external customer, you run the risk of someone taking your source code, co
Generic Architecture for Caching Table Data: Supercharge Your Cache
(Mark Vilrokx) In the first part of this series we started of by putting the basic structures in place for a cache and wrote some code to manage the cache. In this next part, we will extend the functionality of our cache.
Oracle Critical Patch Update – October 2005
A Critical Patch Update is a collection of patches for multiple security vulnerabilities. It also includes non-security fixes that are required (because of interdependencies) by those security patches.
SAP launches midmarket push against Microsoft, Oracle
(Robert Westervelt) SAP is ramping up its midmarket sweep for customers against rivals Oracle and Microsoft, with the launch of new versions of its preconfigured software templates aimed at midsized businesses in nearly 30 specific industries. (R)