By Amar Kumar Padhi – Part 2 of this series covers the Initialization parameters and Hidden or Internal Oracle parameters that influence the Optimizer in choosing execution plans. It is very important to setup these parameters properly.
Tag: Oracle
Is Linux Ready for the Database?
By Lisa Vaas – As Oracle Corp. girds for the upcoming release of its Oracle 10G database next month, the company is cranking up the G-for-grid part of the message for this major update.According to beta users, the update will feature easier-to-configure grid capabilities. But a big part of O
Querying When Table and Column Names are Unknown
by N. Venkatagiri – If you have to run a query for some data but don’t know the table name and the column name, the following query will run the query. Replace the TEXT_VALUE with the text you want to search.
Oracle 9i XML component vulnerable
By Ellen O’Brien – A set of buffer overflows in the XML component of Oracle Corp.’s 9i database makes it highly vulnerable to attack through a company intranet portal. Oracle is urging customers to immediately patch the vulnerabilities and to avoid connecting the database to the Internet until they
Oracle Regular Expressions Pocket Reference
By Jonathan Gennick, Peter Linsley – Oracle Regular Expressions Pocket Reference is part tutorial and part quick-reference. It’s suitable for those who have never used regular expressions before, as well as those who have experience with Perl and other languages supporting regular expressions. The b
Managing Oracle9iAS Release 2
By Ken Jacobs – Enterprise applications are becoming increasingly sophisticated; by extension, the platforms and servers that support them have had to become advanced, flexible, and more fully featured. A critical element to any worthwhile application server is its ability to integrate these various
Promoting the Penguin
By Robert Hall – Robert Clevenger is principal product manager for Oracle9i JDeveloper at Oracle. During the first few months of this year, he traveled across the United States, visiting Java and Linux user groups and presenting and discussing options and strategies for application development on th
Oracle XDB Flaws Open Door for Hackers
By Lisa Vaas – The XDB (XML Database) in Oracle Corp.’s Oracle9i Database Release 2 has a set of potential buffer overflows that a smart attacker could exploit to cause a denial-of-service (DoS) attack or to capture an active user session on Oracle9i, the company’s OTN (Oracle Technology Network) in
Oracle goes ‘grid’ for app server
By Martin LaMonica – Oracle next month plans to provide details on an update to its application server software and development tools, tied to the company’s emerging “grid” computing strategy.
Oracle Mute About 10G
With the annual Oracle World San Francisco conference just around the corner, the hype over Oracle’s soon-to-be-announced 10G database has reached a crescendo — or so you would expect. But unlike past releases, this one has so far remained a closely guarded secret thanks to Oracle representatives’ e