(Marc L. Songini) A number of Oracle Corp. users are showing interest in the recently shipped 10g database, citing the software’s new manageability, usability and self-tuning features. In addition, because prices were recently slashed, some are suggesting that 10g could rival Microsoft Corp.’s SQL S
Tag: Oracle
Oracle’s rose-colored grid vision
(Ellen O’Brien and Robert Westervelt) More than six months ago, Oracle Corp. CEO Larry Ellison announced to thousands of OracleWorld attendees that grid computing was going to rock their IT worlds. (R)
Unwrapping Oracle’s DBMS Packages: Understanding Oracle’s Random Number Generator
(Steve Callan) Beginning with later versions of Oracle8, Oracle has provided a means of generating random numbers. This built-in package, DBMS_RANDOM, is fairly simple to use, and can generate random numbers which are generally good enough for the needs of most users. If you need to generate a large
Core to Your Business
(David A. Kelly) When Scott Klimke, CIO of Network Appliance, Inc. (NetApp), a nearly US$1 billion supplier of storage solutions, says that his company’s IT philosophy is to keep it simple, that’s not because it hasn’t tried other options. “During the late 1990s, we were growing at 70 to 100 per
Materialized Views
Materialized views (MVs), also known as snapshots, have been around for quite some time now. MVs store the result of a query in a segment and can return that result to the user when the query is submitted, eliminating the need to re-execute the query—an advantage when the query is issued several tim
Parsing in Oracle
(Amar Kumar Padhi) Whenever a statement is executed, Oracle follows a methodology to evaluate the statement in terms of syntax, validity of objects being referred and of course, privileges to the user. Apart from this, Oracle also checks for identical statements that may have been fired, with the in
Dr. DBA takes pulse of 10g
(Robyn Lorusso) The International Oracle Users Group handed out its first “Oracle Contribution Award” at this week’s IOUG Live! conference in Canada. Ken Jacobs, Oracle Corp.’s vice president of product strategy for server technologies and the man known as Dr. DBA, was its recipient. Prior to the aw
Serving HTML DB Reports
(Sergio Leunissen) Every organization needs to deliver reports on the Web. Often, slight variations of the same report need to be created for different end users. If you are a Web developer or a DBA who frequently needs to deliver reports and you want to make those reports more flexible or your
Comparative Management Cost Study of Oracle Database 10g and Microsoft SQL Server 2000
Progressive Strategies has performed a Comparative Management Cost Study (CMCS) comparing Oracle Database 10g and Microsoft SQL Server 2000. This effort came about as a result of our review of the pre-release announcements from Oracle Corporation regarding the features and manageability benefits the
Dynamic Reconfiguration and Oracle 9i Dynamically Resizeable SGA
This article explains how Oracle 9i can operate in combination with Sun’s dynamic reconfiguration (DR). It provides a brief overview of DR, intimate shared memory (ISM), dynamic intimate shared memory (DISM), and dynamically resizable system global area (SGA), and explains how these technologies fit
