|
At Oracle BRIEFS
Briefs
Oracle Database 10g Speeds to New Performance Records
Extending a more-than-25-year commitment to high performance, Oracle has announced a string of new benchmarks for Oracle Database 10g and Oracle Application Server 10g, including a TPC-C transaction-processing world record, a record 4-CPU TPC-C single-system Linux result, a 32-CPU TPC-C record result on 64-bit Windows 2003,
a world-record TPC-H one-terabyte result, and record SPECjAppServer2002 Multiple Node and
Dual Node benchmark
results on Linux.
Visit www.spec.org/jAppServer2002/results/jAppServer2002.html
for details.
Grid Control Is Here
As part of the Oracle Enterprise Manager 10g release, Oracle has introduced Oracle Grid Control, new software designed to help customers monitor and manage entire Oracle grid infrastructures—rom databases and applications to storage—all within a single console. Oracle Grid Control is the industry's first grid management product to recommend expert advice on how to better plan for capacity, availability and performance needs within a grid. At the core of Oracle Grid Control is a "control repository" that contains performance, availability and configuration data about the entire enterprise, as well as a set of centralized management capabilities that transform and configure data into valuable information. Using Oracle Grid Control, administrators can reduce the complexity of managing multiple servers in a cluster and automate the management of computing resources.
"The key to managing high-performing, fully-managed solutions in a widely distributed enterprise is to build an environment with as much standardization and repeatability as possible," says Warwick Calkin, group manager, Platform Services, Telstra Corporation. "Oracle Enterprise Manager 10g provides a single, integrated solution to manage thousands of systems from a single HTML console. We will use Oracle's new management software to maximize the availability, performance, and reliability
of Telstra's entire environment."
"Oracle Enterprise Manager 10g is
a product of Oracle's world-class data center management experience, delivering new levels of automation and intelligence to help administrators increase productivity," says Charles Rozwat, executive vice president, Server Technologies, Oracle.
|
Did You Know?
E-mail is No. 1
E-mail has replaced the telephone as the most frequently used business communication tool, according to a study sponsored by Oracle and conducted by KRC Research. Fifty-six percent of professionals said they could not live without e-mail, and 44 percent said they use e-mail almost twice as much as they use the telephone. Sixty-five percent of respondents agree that being able to access their e-mail, voice mail, and faxes from a telephone would be very useful.
Source: Oracle/KRC Research
oracle.com/ip/deploy/cs/
theme_pages/user_research.pdf
|
Hundreds Benefit from Oracle Collaboration Suite
More than 500 organizations worldwide have purchased Oracle Collaboration Suite since its release in September 2002. Prominent adopters
of the product include Dallas County, Texas; OneSource; Tivo Inc.; the U.S. Department of Energy; the U.S. Department of Labor; the University
of Southern California; ViewSonic; and the Washington Post.
Oracle Collaboration Suite employs the Oracle Database and Oracle Application Server to provide secure, scalable business communications. By replacing specialized applications with a single relational database, companies running Oracle Collaboration Suite can reduce the number of servers they manage and improve service levels.
Independent research confirms this. Cambridge, Massachusetts-based Forrester Research conducted in-depth interviews with Oracle Collaboration Suite customers and published its findings in a "Total Economic Impact" report in July 2003. Forrester's report stated that Oracle Collaboration Suite offered a three-year risk-adjusted return on investment of 234 percent for a representative organization, and that migration to Oracle Collaboration Suite was cash flow-positive within the first year. The three-year, risk-adjusted cost savings with Oracle Collaboration Suite was roughly US$1 million for a representative organization. (The complete Forrester report is available for download at oracle.com.)
Oracle Leads Geospatial Database Management Market
Basic spatial information management capabilities will be ubiquitous in database, application server, and data-access technology in two to three years, according to Framingham, Massachusetts-based research firm IDC. Also known as geospatial capabilities, the technology is used to map sales territories and business locations, assets for utility companies, city grids for emergency planning, and the like.
IDC also reported that Oracle currently holds between 80 and 90 percent of the market for spatial information management (SIM)-oriented database installations. "Oracle remains the top choice for spatial information management technology due to its built-in spatial and location-enabled database technology," says David Sonnen, IDC's senior consultant for spatial information management. Sonnen notes that Oracle9i Database "embeds these features at no additional cost and, in many cases, allows applications to access geospatial data directly from an Oracle database."
A new class of location applications is taking advantage of geospatial capabilities: for example, concierge services that map hotels, restaurants, and other service outlets. E-business applications such as call centers can also benefit from mapping and spatial analysis.
Oracle geospatial products conform to open standards, particularly in the area of location-based services. The company is committed to the OpenGIS Consortium Simple Features guidelines and is supporting the new OGC Geographic Markup Language and Open Location Service interfaces. The object-relational model used for geometry storage by Oracle also conforms to the specifications associated with SQL92 representation of points, lines, and polygons.
New Tool Speeds and Eases
Linux Migrations
A free tool is now available to help Oracle E-Business Suite users migrate their Oracle applications from any platform to low-cost Linux. Using the Linux Platform Migration Utility, customers can automatically migrate their middle-tier applications, preserving the application patch level and all customizations. Using the Linux Platform Migration Utility also eliminates the need for database synchronization or retooling.
Customers provide information about their premigration Oracle environment using a form on the Oracle.com Web site. The information is analyzed, and a customer-specific migration patch is generated and sent electronically. Using the migration patch, a Linux migration can be completed in less than a day with minimal downtime and user interruption.
"Most customers are aware that Linux provides the best performance at the lowest cost, but a multimonth migration project is a formidable obstacle for anyone," says Ric Ginsberg, Oracle's vice president of Applications Release Engineering. "With the Linux Migration Utility, customers can migrate to Linux in less than a day."
More information about the Linux Platform Migration Utility, including
an internet seminar with Oracle Development Manager William Greene,
is available on oracle.com.
Oracle Unveils Future Business Intelligence Tools
Early next year, Oracle will release new technology based on its unified, integrated relational and OLAP databases
and tools that will make business intelligence (BI) more powerful.
"Oracle BI delivers the right information at the right time, so you can make the right operational, tactical, and strategic decisions," says Oracle Vice President for BI products John Entenmann. "Oracle Business Intelligence is complete and integrated. Our comprehensive, cost-effective BI solutions include all the applications, tools, technologies, and services you need."
In September, during an OracleWorld San Francisco session, Entenmann performed live product demonstrations, including a sneak peek at the forthcoming Oracle Discoverer "Drake." Drake is the code name for the forthcoming Discoverer product set for beta release in January, 2004 and in production later in 2004.
"With Oracle Discoverer Plus, you get a Web-based product with a Java interface to access powerful, unified, multidimensional data," explains Entenmann, who demonstrated the Drake preview of Discoverer with live data from a fictitious audio/video equipment supplier, including sales data and locations.
By simply dragging and dropping data selections, Entenmann used Discoverer to drill, rotate, and pivot on the data—no code typing required. He also demonstrated a Calculation Wizard that makes quick work of running multidimensional calculations—again, with no code required.
Entenmann highlighted the openness of Oracle's BI tools, which interoperate with products from Business Objects, Informatica, Plumtree, BEA, and Microsoft. In another OracleWorld sneak preview, Entenmann demonstrated a forthcoming version of Oracle OLAP Excel add-in, which allows you to leverage the power of Oracle BI from within Microsoft Excel.
|
Sample Code: Recompiling invalid PL/SQL objects
PL/SQL stored objects such as packages and triggers can become invalid when objects they reference are altered or re-created. This script generates SQL that can be used to recompile invalid objects.
***********************************************************
-- File Name : recompile_invalid.sql
-- Author : Krishna Kakatur
-- Date Written : 12th Dec 2002
-- ***********************************************************
set pagesize 0
set feedback off
set termout off
spool recompile.sql
SELECT distinct 'ALTER '||
decode(object_type, 'PACKAGE BODY', 'PACKAGE',
object_type)||
' '||owner||'.'||object_name||' compile'||
decode(object_type,'PACKAGE BODY',' body')||';'
FROM dba_objects
WHERE status='INVALID'
AND object_type IN ('PACKAGE','PACKAGE BODY','VIEW',
'FUNCTION','PROCEDURE','TRIGGER');
spool off
Krishna Kakatur (kakatur@hotmail.com) is a database administrator with Sun Microsystems in Newark, California, and has more than 10 years of experience with Oracle technology.
|
|
Bookmark
