Reports Builder provides the Graph Wizard to insert graphs in both Paper and Web Reports. Reports Builder uses what you specify on each page of the Graph Wizard to create an XML file (graph.xml). This XML file is used to create the look-and-feel of the resulting graph at runtime. A common require
Tag: Oracle
Changing an Oracle DBID (Database Identifier) in Oracle 8i and 9i Release 2
(Bertram Moshier) During an Oracle database generation, the process generates an unique number called the DBID (Database Identifier). Many developers and administrators fail to change the DBID when cloning an Oracle database. This presents problems to some Oracle products (e.g. OEM and RMAN) and thi
Grading Grid Computing
(Michael Otey) Welcome to the latest IT buzzword: grid computing. Also known as utility computing or on-demand computing, this technology has almost as many definitions as it has monikers. At its lowest level, the goal of grid computing is similar to that of Microsoft’s Trustworthy Computing initiat
Diagnosing Performance Problems
(Cary Millsap) Suppose that one day you are driving to work and end up arriving late for an important meeting. You aren’t able to present your revolutionary idea, so your clients aren’t going to use it. You’re frustrated by your tardiness and vow to never make the same mistake again. So how do you d
Caching Oracle Data for ASP.NET Applications
(Narayan Veeramani) For building scalable and high-performance Web based applications, ASP.NET provides a feature called data caching. Data caching enables programmatic storing of frequently accessed data objects in memory. This feature can be extended to vastly improve performance for ASP.NET appli
Fine-Grained Auditing for Real-World Problems, Part 2
(Arup Nanda) In the Part 1 of this series, I described how to build a Fine-Grained Auditing (FGA) system to audit select statements, capturing the statements depending on certain conditions—a task impossible in regular auditing or though the use of DML triggers and the Log Miner tool. In addition to
.NET and Oracle Java Stored Procedures—Bridging the Gap with XML
(Jeff Hilts) Using Oracle as your database in the .NET environment is relatively simple, except when returning JDBC ResultSets from Java stored procedures. The Microsoft and Oracle .NET data provider drivers allow for easy access to data from SQL queries and PL/SQL stored procedures. There is not, h
Adding Value with Ultra Search
(Douglas Scherer) Oracle9i adds new multisource search capabilities through Oracle Ultra Search, which lets you easily combine data from multiple source types into one searchable index and provides a configurable crawler. The crawler visits the specified data sources at scheduled times, follows link
The Trigger-Happy DBA – Part 2
(Steve Callan) Here is a problem many developers run into: ORA-04091 table owner.table_name is mutating, trigger/function may not see it. In many cases, the cause of this error is due to code within a trigger that looks at or touches the data within the table the trigger is being called or invoked f
Bulletproofing, Backups, and Disaster Recovery Scenarios
(Stephen Rea) Yes, you really can bulletproof your database so that it is always up and available and you never lose any data from almost any disaster scenario – for a price. You can run parallel servers in separate locations, have hot standby databases for quick switchovers, and implement replicate
