(Amar Kumar Padhi) Oracle requires an initialization file to define the attributes and characteristics of the starting instance and the connecting sessions there of. We are aware of the Initialization parameter file (also referred as init.ora file or PFILE). This file holds the setup parameters that
Tag: Oracle
Oracle Still Sitting on Database-Security Patches
(Lisa Vaas) Oracle Corp. is in public-relations hot water after weeks of stony silence on its delay in releasing 34 security vulnerabilities patches for flaws it has known about since January or February.
Handling Oracle Max Open Cursor Error when Fetching Multiple Rows in ADO.NET
(Vivek Shaurya) Generally while working with Microsoft technology, MS-SQL server comes out as a natural choice for the database. While it’s a fact that .net framework has extensive support for SQL server, when you work with other databases like oracle the situation might turn out to be a little more
9i RAC is the ticket for StubHub
(Michael S. Mimoso) Linux has a prominent role sustaining many if not most online businesses as a Web server. But as the operating system evolves, so does its responsibilities. (R)
Oracle ADF Faces Components, Early Access Release
Oracle ADF Faces is a rich set of user interface components based on the new JavaServer Faces JSR (JSR-127). Oracle has been actively involved in this JSR since its beginning. The Oracle ADF Faces Components provide various user-interface components with built-in functionality – such as data tables,
Developing Faces
(Chris Schalk) Building enterprise J2EE Web applications has always been a bit of an art. Although J2EE provides more-than-adequate foundational technologies for building scalable enterprise Web applications, it previously lacked a high-level API to glue these technologies together and provide a sin
Physical Storage in Oracle
Here’s a outline-style look at the different storage elements involved in an Oracle database system.
Oracle Scheduler
(Arup Nanda) Some of you may use the dbms_job package extensively to submit database jobs to be run in the background, control the time or interval of a run, report failures, and much more. However, I have a feeling that most of you don’t. The problem with the package is that it can handle only
Enterprise Manager 10g Backup, Recovery and Disaster Recovery Considerations
The newest release of Oracle Enterprise Manager Grid Control presents a dramatic architectural departure from the previous releases, incorporating a portable browser based interface to the management console and Oracle’s application server technology to serve as the middle-tier Management Service (O
Get Table Details with SQL*Plus
(Ajay Garg) You can use SQL*Plus to provide the following details about a table: 1. Column Details 2. PRIMARY KEY 3. INDEXES 4. FOREIGN KEYS 5. CONSTRAINTS 6. ROWCOUNT 7. Other Tables That REFER to this Table 8. PARTITIONED COLUMNS 9. PARTITIONS 10. TRIGGERS 11. DEPENDANTS
