|
AT ORACLE: BRIEFS
Oracle 10g Now Available
Oracle Database 10g, the latest release of Oracle's database, is now generally available. Designed for use in an enterprise grid computing environment, the database contains hundreds of new features designed to improve performance, increase scalability, and automate many routine management tasks.
Oracle has been working for years on technologies that support the vision of grid computing, and those technologies are now found in Oracle 10g. Features such as Automatic Storage Management (ASM), Oracle Resource Manager,
Oracle Scheduler, Oracle Transportable Tablespaces, and Oracle Streams will help administrators provision resources and data for use in a grid environment. Furthermore, Oracle 10g has enhanced management tools for administering the database in an enterprise grid.
To help ease database management, Oracle Database 10g contains a new intelligent infrastructure that continually collects statistics about database performance, helping administrators better
identify problem areas.
A new set of advisers
and an engine built into the database kernel
called Automatic
Database Diagnostic Monitor (ADDM) are the cornerstones of this new infrastructure, letting administrators view
everything from space usage to problem SQL.
The new database
is now available for download from Oracle Technology Network.
Oracle 10g Enhancements for .NET Available
Oracle Database 10g, now available, contains enhancements for Windows and .NET developers. These developers can use Oracle Data Provider for .NET (ODP.NET) for connectivity between Oracle Database and .NET applications. And, with grid enhancements, ODP.NET lets .NET developers take advantage of Oracle Database 10g's grid capabilities.
"Ironically, there are things Oracle can do with .NET today that SQL Server can't," says Alex Keh, Oracle's principal product manager for Windows technologies. "This includes the ability to have more than one DataReader open at a time, the flexibility to tune the performance of LOB retrieval, XMLType, and parameter-array binding."
Monitor and Manage with New
Grid Control
Enterprise grids can be too large to manage manually, and the less
time administrators spend with time-consuming, error-prone tasks, the better. That's why Oracle Enterprise Manager 10g includes Oracle Grid Control, a centralized management console that automates software installation, patching, upgrading, workload balancing, security, and more.
At the core of Oracle Grid Control is a control repository that contains performance, availability, and configuration data about the entire enterprise. In addition to managing Oracle Application Server 10g and Oracle Database 10g, Grid Control tackles Web applications via Application Performance Management, hosts, storage devices, and server load balancers. And, with an extensible SDK, you can use it to monitor just about anything.
New RosettaNet Adapters for Oracle Application Server 10g
|
Did You Know?
Java Is Best for Web Services, Say Developers
In five out of six categories, developers consider Java to be the best language for developing Web services. Java beat C# in flow control, syntax, object/memory separation, easy access to libraries, and tight integration with XML. Developers consider C# better in tight integration with SOAP.
Source: Evans Data Corporation
Many Web Sites Have Serious Errors
One in seven Web site home pages fail a simple link integrity test, with one or more errors severe enough to cause visitor defection. Of 239 well-known consumer-facing Web sites tested, 24 had broken links ("404" errors), 14 provoked server errors, 5 linked to sites with nonexistent host names, and 3 pointed to servers that responded with "server unavailable" errors.
Source: Jupiter Research
|
Companies that want to connect to Intel and Cisco using RosettaNet
can now do so seamlessly with Oracle's RosettaNet implementation, which is
precertified for both companies.
RosettaNet is an emerging standard that specifies business processes that
span between trading partners across
the internet. Oracle Application Server 10g Integration follows the RosettaNet Implementation Framework (RNIF) v1.2 and provides out-of-the-box support for a large number of Partner Interface Processes (PIPs). RosettaNet enables a company to rapidly establish connections with business partners and create an integrated supply chain.
New Oracle RosettaNet adapters for Oracle Application Server 10g make it possible to connect to your trading partners. These adapters enable the transfer of messages between trading partners by converting any type of internal-document format to RosettaNet Business Object Documents and then back to the receiving partner's internal format. The RosettaNet adapters are available separately and can be downloaded from the Oracle Technology Network. The RosettaNet adapter is priced at US$30,000 per CPU.
Oracle and HP Run 1.18 Million Transactions per Minute on Linux
A new, independent benchmark* suggests that Linux is ready for the enterprise, as Oracle broke the 1 million-transactions-per-minute barrier. Oracle Database 10g with Red Hat Linux on a cluster of HP Integrity servers with Itanium 2 processors hit a record 1,184,893.38 transactions a minute at US$5.52/tpmC. "We have now shown that Oracle Database 10g Real Application Clusters can deliver the world's best transaction-processing performance on clusters of low-cost industry-standard servers running Linux," says Andrew Mendelsohn, Oracle's senior vice president for database development.
Together, Oracle and HP hold the only two TPC-C-published TPC-C results over 1 million transactions per minute.
New Oracle Collaboration Suite APIs Available
Oracle Collaboration Suite users can now leverage the suite's existing set of collaboration services to develop more customized applications that offer additional benefits to the enterprise. Oracle is offering functional-level access methods to the underlying applications and user-interface customizations, and application-programming interfaces (APIs) are included with the product CDs.
As a by-product of consolidating content to a single datastore, Oracle Collaboration Suite offers the opportunity to develop against a corporate repository that is the single source of truth for all collaborative data within an enterprise. The APIs serve as a powerful mechanism for developing applications that use the underlying collaborative infrastructure. In addition, support for open protocols in the suite offers possibilities for development beyond what the APIs provide.
31-Day Free Trial for Real-Time Collaboration
Oracle is offering a 31-day trial period of Oracle Web Conferencing and the ability to collaborate in real time with your coworkers and partners. Oracle Web Conferencing is an enterprise solution that enables individuals and groups to meet online to collaborate and to share presentations, applications, or their entire desktop while increasing reliability and security and reducing costs.
Oracle Web Conferencing charges a license fee per employee, not a per-meeting cost. A perpetual license for Oracle Web Conferencing costs US$45 per user, and an annual license fee is available for US$11 per user.
Users Adopting Stretch Clusters
Although you can't eliminate the threat of natural disasters, Oracle is working to help your business data survive problems. Stretch clusters—distance clusters, geo-clusters, or extended clusters—are designed with disaster tolerance in mind, and Oracle's customers are beginning to adopt the technology.
"Stretch clusters are Oracle Real Application Clusters that have some distance—anywhere from a few miles to a few continents—between server nodes," says William Hardie, Oracle's director of product marketing. "By separating server nodes and storage in different locations, data-center resources are fully protected from accident and disaster."
With 182 million passengers a year, Austrian Federal Railways uses Oracle Real Application Clusters to protect 80GB of data tapped by 1,200 users. The stretch cluster handles applications that manage the entire railway infrastructure, which includes nearly 3,600 miles of track, 6,000 bridges and viaducts, 240 tunnels, and nearly 7,000 crossings.
Switch & Save Continues
Since Oracle kicked off the Switch & Save migration program from BEA WebLogic to Oracle Application Server nearly a year ago, many businesses have migrated, and many more are in process. New customers point to two reasons for switching: cost and consolidation.
The Switch & Save Program offers customers the ability to swap their
BEA WebLogic processors for Oracle Application Server Java Edition processors (US$5,000 per processor) at no
cost, with a guarantee of 50 percent savings on support costs. And although Oracle charges roughly the same rate for 24/7 support as BEA (Oracle charges 22 percent, while BEA charges 21 percent), its license costs are lower, which decreases support costs. Future application-server purchases will also be less for customers who switch, since license costs are lower for Oracle.
*Source: Transaction Processing Council (TPC), www.tpc.org. As of December 8, 2003: Sixteen-node HP Integrity rx5670 server cluster, each with 4 Itanium 2 1.5 GHz processors, 1,184,893.38 tpmC, $5.52/tpmC, available April 30, 2004. HP Integrity Superdome server with 64 Itanium 2 1.5 GHz processors, HP-UX 11iv2, 1,008,144.49 tpmC, $8.33/tpmC, available April 14, 2003.
|
Sample Code: Get Info By Username
The following code gets the hit ratio and I/O data based on username within the database, letting you see which users are using the most resources.
SELECT username, osuser, io.physical_reads, io.block_gets, io.consistent_gets, ROUND(100*(1
(io.physical_reads/(io.block_gets+io.consistent_gets))),3) "Hit Ratio", sess.sid, stxt.sql_text
FROM v$sess_io io, v$session sess, v$sqltext stxt
WHERE io.sid = sess.sid
AND (io.block_gets +io.consistent_gets) ! = 0
AND username IS NOT NULL
AND stxt.address = sess.sql_address
AND stxt.hash_value = sess.sql_hash_value
ORDER BY ROUND(100*(1-(io.physical_reads/(io.block_gets+io.consistent_gets))),3),
sess.sid, stxt.piece;
Kishore Surve (kishoresurve@yahoo.com) is a database administrator in Mumbai, India.
CodeLocator
More code tips
Sample code
|
|
Bookmark
