(Bob Watkins) Oracle 10g introduced a new type of tablespace called BIGFILE. Unlike traditional tablespaces that are composed of up to 1,022 datafiles, a BIGFILE tablespace stores its data in a single datafile with a much larger capacity. BIGFILE tablespaces can grow as large as 32-128 terabytes (TB
Tag: Oracle
The Role of the DBA Related to Insider Threats and Regulatory Compliance
(Alex Polishchuk and Michael Procopio) We all remember too well the cases of Enron and WorldCom. In light of those cases, the government has created new laws commonly known as the Sarbanes-Oxley (SOX) Act of 2002 to protect investors and insure the accuracy of corporate disclosures. SOX-type regulat
Manually creating a Logical Change Record (LCR)
(Lewis Cunningham) I’ve been doing quite a bit recently with Oracle Streams. I recently had the need to create some test data in LCR format. If you have manual control of your LCR, you can test specific data issues a lot easier.
QUEST CODE TESTER : Unit Testing Your PL/SQL Code – II
(Partha S) As Steven and Jim pointed out in my last post – Unit Testing Your PL/SQL Code , the QUESTCODETESTER id needs to have execute privilege on the UTL_FILE utility.
Expanding to Meet Demands
(David A. Kelly) Small business doesn’t mean small requirements. Take the case of fast-growing Bebo.com, the United Kingdom and Ireland’s most popular social networking site.
How to create a New Custom JSF Component that randomly displays select items in SelectOne… and SelectMany components
(Lucas Jellema) Selection components, such as Radio Buttons. Dropdown-lists, Lists, Shuttles and Check Boxes, are key elements of many a web page. Java Server Faces has a pretty wide range of such selection widgets available, from selectOneRadio to selectManyCheckbox in the RI and a wide range of a
Oracle Rumored to Covet Ingres
(Tamina Vahidy) Oracle might be looking to acquire open source database provider Ingres, according to speculation from analyst Bruce Richardson of AMR Research.
Oracle links database developer tool to rivals
(Paul Krill) Oracle is shipping an upgrade to its free database development tool, adding a number of enhancements, including the capability to access competing databases such as Microsoft Access and MySQL.
Is a 24X7 database system a myth
(James F. Koopmann) Is a 24X7 database system a myth? Let me just say for the record, YES it is. At the root of the question is the definition availability which has the notion of being ready for use, at hand, and accessible. With 24X7 that means 100% availability and completely accessible. I offe
Transaction And Locking Modes
(Assaf Arkin) In order to understand how the JDO transaction model affects applications performance and transactional integrity, you must first understand the semantics of the Java Data Objects. Java Data Objects are objects loaded from and stored to the database, but are disassociated from the data
