(Bobby Akbari) This script analyzes a given table and all underlying indexes within the executing schema.

(Jim Czuprynski) Oracle Label Security (OLS) offers a powerful implementation of row-based security that is perfect for restricting user access to specific data, especially in a data mart or data warehousing environment. Previous articles presented a brief overview of how these features work, and ho

(James Koopmann) This is the second part of the two part series on helping you answer those tough questions that you might experience in your quest for an Oracle DBA position. The Oracle Technical Interview can be quite daunting. You never quite know what to study for and how to prepare. I am fu

(Steve Muench) The new Oracle Application Development Framework (ADF) in Oracle JDeveloper 10g evolves our road-tested BC4J framework to a new level of flexibility and openness. By introducing a new “data control” abstraction for back-end business services and generalizing our existing data binding

(Lannes Morris-Murphy) Various generations of the Oracle Database have introduced features to simplify the task of database administration. For example, when used with a recovery catalog, the Recovery Manager (RMAN) component introduced with Oracle8 gave database administrators (DBAs) the option of

(Bob Green) Recently we have had a number of customers contact our technical support team with questions and problems having to do with migrating TurboIMAGE data fields to Oracle. Since the two databases do not support the exact same datatypes, there are a number of cases where problems can arise.

(Sudhakar Ramakrishnan) Remember the heady days of HTML version 1.0 to version 2.0, when mastering a new Web language was as simple as looking at the code behind a Web site? Remember the ease of learning that came with basic HTML? Remember being able to hack out some code, quickly view the presentat

(Matt Krantz) Before the Internet bubble burst, there were four companies that, in Wall Street’s eyes, could do no wrong: Cisco, EMC, Sun Microsystems and Oracle. Prosperous records, real products and soaring profits earned them the nickname, “the Four Horsemen of the Internet.”

(Amar Kumar Padhi)We covered the various methods of generating statistics in the last installment; moving forward, let’s look at the data skewness problem and the use of the Monitoring option for updating statistics on the fly.

Oracle and HP set a new world-record Transaction Processing Council TPC-C benchmark of over one million transactions per minute on a cluster of Linux servers. The result was achieved Oracle Database 10g, HP Integrity servers with Intel Itanium 2 processors and Red Hat Enterprise Linux AS 3.0. Th