(Scott Stephens) Oracle’s Heterogeneous Services layer is a way for an Oracle database server to access data on external, non-Oracle databases transparently using Oracle.
Tag: Oracle
Database Interaction with PL/SQL, Introduction to Cursors, Implicit Cursors
(Jagadish Chatarji) This is part nine of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, we looked at different tips for using nested blocks together with exceptions. In this article, we will see how to handle exceptions centrally and have a look at
Oracle researcher announces high-risk flaws
(Shawna McAlearney) Concerned with the dangers posed by multiple vulnerabilities left unpatched by Oracle, a security researcher has gone public with information on six flaws — three high-risk — and recommends workarounds. (R)
Sorcerer of OO – Part 4
(Lewis R Cunningham) In Part 1 of this series, we talked about how Oracle objects compare to Java and how to create Oracle objects. In Part 2, we covered object comparison and type inheritance. And in Part 3, we covered polymorphism and type evolution. Today, I’m covering the creation of Object Tabl
Patch Management: Stop Killing the Database to Save It
(Charles Garry) Opinion: Instead of racing to provide new features, database vendors should take the time to upgrade patch management tools.
Release 2 Addendum, Part 3: Performance Features
(Arup Nanda) Let’s assume that you use Oracle Enterprise Manager to diagnose and solve performance issues. One day, a nasty issue arises: a badly designed application is causing serious library-cache lock issues and the database appears to be hung. You have to quickly identify the culprit sessions a
Efficient Space Management
(Aradhana Puri) Oracle Database 10g provides a variety of features for managing the space usage of a tablespace. These features include the monitoring of tablespace usage, the ability to suspend transactions that require more space and successfully resume them when the space is available, and a data
Oracle Defends Its Math on Multicore Discount
(Lisa Vaas) Oracle Corp.’s vice president of pricing and licensing defended the math behind the company’s new and comparatively stingy 25 percent rebate on multicore processors, saying that customers are now getting charged for what they in fact get: a 1.5 to 1.75 times performance boost from a dual
Oracle Forms: Can you get it to perform on a WAN?
(Grant Ronald) Like buses, sometimes I never hear questions about Forms performance and then this week – bang – three come along at once. Now, I am going to let you into the biggest secret in testing your Forms application for performance issues….you ready?…..KISS!
DeployPHP Series, Part 2: Bringing Data Security to PHP Applications
(Mikhail Seliverstov) Using PHP to build a Web-based, database-driven application is an increasingly popular way to give trusted users easy access to corporate data. However, the PHP developers must acknowledge that linking sensitive and often mission critical data to an application accessible outsi
