(Steve Callan) One of the more fascinating toys or objects in a grade school science class is magnets. Give an adult two magnets, and the childhood fascination takes over. Invariably, that person will start putting the magnets together in attempts to make them join and repel. Many people have forgot
Tag: Oracle
OOW: Enhancements in Oracle 11g PL/SQL
(Lewis Cunningham) I apologize in advance for any typos or spelling errors. I’m standing here typing this at the Oracle Connection Center in Moscone South. It’s just a browser so no spell checker. BTW, it’s MSIE. No firefox on the connect PCs.
Oracle 11g Database in Beta Testing
(China Martens) Oracle has started laying the groundwork for the next major release of its database, Oracle 11g.
IOPS / MPS Workload for Oracle
(James F. Koopmann) Are you running Oracle 10gR2? Well, What kind or workload / application mix do you have running? Is it OLTP, OLAP or something in between?
RAC node scaling in DSS workloads vs. OLTP
(Bill Cullen) What are your experiences with RAC node scaling in DSS workloads vs. OLTP? Also, isn’t the primary bottleneck in scaling out the overhead of the cachefusion lock management protocols, not the actual interconnect? (R)
Think ANSI Standard SQL Is Fully Portable Between Databases? Think Again
(Alexander Kuznetsov) Out here in the field, there is a popular urban legend: “If your application issues only ANSI standard SQL, then your application is portable.” Many developers actually believe it. Unfortunately in some cases, identical SQL works differently on different RDBMS. This article pre
Wiring Through an Enterprise Service Bus
(Brian Wilkinson and Demed L’Her) As the idea of implementing Service Oriented Architecture (SOA) gains traction, enterprises are finding themselves with an increasingly large portfolio of services. Effectively leveraging and reusing these services can prove challenging unless you follow the correct
Introduction to Business Process Execution Language (BPEL)
(Nicholas J. Donatone) Before we jump right into a discussion on Business Process Execution Language (BPEL) we need to set a framework for its use. It is important for managers, developers and DBAs to have an understanding of how BPEL can benefit them. This article will give you an introduction to B
Oracle RAC Administration – Part 7: Starting and Stopping the Database Instances and RAC Databases
(Tarry Singh) Talking about syntax and theory is nice. It is good to know the facts and it is fine to know what syntax to use where. I can also assume that you enjoy my articles, but I may be wrong. That is exactly what a polite critique reminded me.
Transaction failover effectiveness
(Bill Cullen) How effective ia transaction failover? If I have session-specific variables set in my session on node 1, are they maintained and accessible from node 2 if node 1 goes down? (i.e., v$session.client_info, mode, action, temp_tables, etc.) (R)
