(Marc Fielding) It often comes up that you need to download Oracle software directly to your database server from OTN. Unfortunately, technet.oracle.com is hostile to non-GUI downloads. GNU wget would be the ideal tool for this and binary versions are available many places (AIX binaries for instance

(Lewis R Cunningham) I was asked by a friend of mine how he could access the XE databases that he has. There’s one on a server, one on a co-worker PC and one on his desktop. All of them are called XE. He’s Oracle literate but not a DBA or developer and was not comfortable messing with much of his […]

(David Baum) Oracle Magazine spoke with Mike Gotta, principal analyst at Burton Group, to discuss new levels of organizational productivity.

(Ian Abramson) In this chapter, we will be covering topics and features available in Oracle Database 10g with which you will need to be familiar when working with large databases. These features are among the more advanced that you will encounter, but they’re necessary, as databases are growing larg

(Jony Safi) This query monitors CPU usage by session, showing information about processes running. It can identify the whole proccess tree.

(Deepak Vohra) Apache Struts Tiles is a Struts subproject that allows for template-based creation of Web UIs. The Tiles Document Assembly Framework enables the assembly of presentation pages (or “tiles”)–written in JSP, HTML, or JavaServer Faces (JSF). Tiles has some advantages over the

(Brian Peasland) I am trying to restore a database where data was inadvertently deleted. I am recovering the deleted data from a backup. My question is how can I merge the two together without writing over my current data? I’m using an Oracle10g database. Thanks for your time and help. (R)

System-wide tuning of an Oracle database often requires the retrieval of detailed event-based information from the data dictionary. The query presented in this PDF file joins the v_$session_event view with the v$session and v$bgprocess views to develop a quick portrait of all event waits, categorize

(oschakravarthi) This tool generates .ASPX, .CS files for a given Oracle Database Schema. It identifies the relations between database objects, designs ASP.NET pages, generates the server side code which includes Error checking and JavaScript Menus with complete navigation. It identifies the referen

(Sachin Kainth) Sometimes, when you’re working with PL/SQL trigger code, you need to determine the type of modification operation that’s been performed on the ‘triggered’ table. You can do this using the INSERTING, DELETING and UPDATING trigger predicates.