(nikhil Chamankar) Check out this and other tips at SearchDatabase.com. (R)
Tag: Oracle
Oracle Extends Another Deadline
By Michael Singer – Oracle Friday postponed yet another deadline in its $7.3 billion takeover bid for applications rival PeopleSoft. The Redwood Shores, Calif.-based software giant said it has extended its announced tender to midnight EST on Wednesday, December 31, 2003. Previously, the offer
Preventing Corruption Before it’s Too Late: Part 1
Marin Komadina discusses Oracle data-block corruption, describing several features of Oracle that may be used at an early stage to detect database corruption.
Index Rebuild with Cumulative Size Limit
by Eugenio Spadafora – If you want to rebuild all the indexes of your database, you probably would like to schedule something nightly that dynamically creates a list of “alter index … rebuild” commands. But, if your database is really big, you should find some criteria to split the commands
Optimizing Oracle Performance
Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning. In Optimizing Oracle Performance, Cary Millsap, former VP o
Oracle’s Default TEMPORARY Tablespaces
Using the SYSTEM tablespace as a temporary tablespace is to be frowned upon, yet Oracle still lets us assign it as such. James Koopmann explores a better way.
Oracle Eyes Linux on iSeries
by Seamus Quinn – When it comes to Oracle and the iSeries, you’d think that never the twain shall meet. The iSeries, after all, comes with its own venerable DB2/400 database, and IBM’s DB2 UDB continues to slug it out with Oracle in the wider enterprise IT arena.
Oracle Taking Laid-Back Approach to Piracy
By Mark Hachman – Oracle Corp. has a message for those obsessed with software piracy: relax.While most of the software industry has begun doggedly tracking down and stamping out instances of illegally copied software, Oracle’s top licensing executive said that her company will tolerate scatt
Improve Results with Query Rewrite
Are you tired of waiting for your queries to return results? Have you already tried adding indexes and tuning the SQL, and still can’t improve query performance? Well, have you considered creating materialized views? With materialized views, reports that used to take hours to run can complete in min
Larry Ellison: Everyone Else Must Fail
By Jim Louderback – With all the hoopla surrounding Oracle, PeopleSoft and Larry Ellison, Karen Southwick’s timing couldn’t be better. Her in-depth look at Oracle’s past, present and future—focusing on Larry Ellison—is scheduled to come out in November.