|
At Oracle BRIEFS
Oracle Application Server 10g Released
Oracle recently announced the release of Oracle Application Server 10g, designed to help bring order to chaos in the middle tier with grid computing. Oracle Application Server 10g provides
a complete middleware layer that transforms a middle-tier infrastructure into
a low-cost, highly efficient, easy-to-manage computing grid.
With Oracle Application Server 10g, administrators can adjust computing capacity based on threshold metrics, such as server utilization rates or end-user response times, or in response to scheduled events. It also provides high-availability capabilities that improve the reliability of application clusters and enterprise grids. Fast Start Fault Recovery Architecture and Failover Notification features simplify communication between the database and application server nodes to provide a coordinated failover response in the event of hardware or system outages.
Oracle Application Server 10g works with Oracle Enterprise Manager 10g, which provides a grid-ready framework designed to simplify the management of sets of systems. Administrators can logically group multisystem application components as well as general homogeneous or heterogeneous sets of systems. These groups can then be more easily managed and monitored as single units or in an aggregated manner.
The new Grid Control capability in Oracle Enterprise Manager lets you monitor and manage your entire grid infrastructure within a single console. It also offers expert advice on how to plan for capacity, availability, and performance needs within a grid. A control repository in Oracle Grid Control contains performance, availability, and configuration data about the entire enterprise, plus a set of centralized management capabilities that transform and configure data into valuable information.
Oracle to Support JavaServer Faces
Oracle plans to include support for
an emerging Web development standard, JavaServer Faces (JSF), in an upcoming release of its JDeveloper application. JSF is expected to make building UI components for Java Web applications faster and less expensive while making way for highly customized, specialized components to be plugged into applications.
JSF provides a standard way to build user interfaces for Java Web applications. With a well-defined programming model, JSF will allow developers to quickly build Web applications by assembling reusable UI components
into a page, connecting these components to an application data source,
and wiring client-generated events to server-side event handles.
JSF includes a set of APIs for representing UI components, handling events, and defining page navigation, to name a few. It also includes a JavaServer Pages (JSP) custom tag library for expressing a JSF interface within a JSP.
|
Did You Know?
Outsourcing Bandwagon Rolls On
Seventy-two percent of companies surveyed are outsourcing multiple IT functions, with 14 percent outsourcing 50 percent or more of their IT work. The No. 1 strategic reason for outsourcing was the lure of cost savings (36 percent); 15 percent say special skills and/or services are the main reason. Of the 31 percent of companies who outsource abroad, 21 percent send their IT functions to India.
Source: 2003 ITtoolbox Outsourcing Survey
emergingtech.ittoolbox.com/research/2003ITOutsourcingSurvey.asp?i=60
|
"Before JSF, Web application development still required custom coding for completion of a Java Web application's user interface," says Chris Schalk, principal product manager for Java tools at Oracle. "With JSF, everyone can code the user interface and navigation model to the same standards and can share components—without being stuck with their own proprietary solutions."
Oracle plans to include out-of-the-box support for JSF in Oracle JDeveloper by mid-2004.
New Survey Data Shows Positive Trend, Says Oracle Support
About six months ago, Oracle's Global
Support Services (GSS) organization implemented a new method of surveying its Americas customers about the quality of Oracle product support. The new method allows customers to rank the service they've received right at the time the service request is resolved, providing both a numerical ranking and comments regarding the service experience.
These new transactional surveys are providing Oracle Support with much-needed and detailed information, much of it positive, according to Michale McWilliams, senior manager for Oracle Customer Satisfaction. "Since June 2003, we've performed more than 8,000 surveys," says McWilliams, "and more than 86 percent of the respondents gave an overall satisfaction rating of average to excellent."
McWilliams and his team are looking particularly closely at "service failures," or areas of customer complaint. "In every complaint area, we have major programs and projects under way to improve our service," says McWilliams. "Additionally, our management team is following up with the customer directly in cases where a customer rates us low."
Some of those projects have led to new skills-based call routing and methods for expediting the dissemination of information to Oracle's support staff. "We also have efforts under way to automatically collect diagnostic information for proactive problem avoidance," says McWilliams. "These are just a few of the ways Oracle GSS is moving beyond simply solving problems to partnering with our customers."
Oracle Database 10g Achieves
1 Million Transactions per Minute
The world's fastest database keeps getting faster. Oracle Database 10g on an HP Integrity Superdome is the first database to run more than a million transactions a minute on the TPC-C benchmark*. The record result—1,008,144.49 tpmC, at $8.33/tpmC—pushes Oracle even further in front of its competitors according to the Top Ten TPC-C Results by Performance.
"These results show that Oracle Database 10g scales to the highest level of performance on a single, large UNIX server and gives customers an excellent platform for deploying their highest performance database workloads, such as credit-card verification and ATM services," says Andrew Mendelsohn, senior vice president, Oracle Database Server Development.
This record-setting configuration consisted of a (nonclustered) 64-way HP Integrity Superdome running HP-UX 11i v2 with Oracle Database 10g and used HP StorageWorks Virtual Arrays 7110 configured with 36GB and 73GB drives.
Better Integration, Reuse in Upcoming Designer Release
New features in the soon-to-be-released Oracle Designer 10g allow developers to reuse existing application designs stored in the Oracle Designer Repository to generate two new application types.
As with Oracle9i Designer, developers can generate portlets for Oracle Application Server Portal by using the same design used by the Web PL/SQL generator. But instead of generating Web applications to appear in their own browser windows, you'll be able to create Web applications as portlets displayed in enterprise portals deployed on Oracle Application Server Portal. This approach lets you take advantage of a common portal framework to deliver personalized, secure access to all the information, based on an end user's roles and responsibilities.
Also, Oracle JDeveloper 10g can now read Oracle Designer's rich meta model to extract table and module information as a source to generate the complete application module and view the object and entity object structure of Oracle Application Development Framework (Oracle ADF) Business Components.
Oracle and Partners Expand Compliance Solutions
Compliance and risk management are two areas of concern facing many CEOs today. In particular, two areas of risk management topping the worry list: compliance with a growing array of government and industry regulations and potential risk associated with evidence discovery stemming from litigation.
Oracle recently announced that it has partnered with key ISVs and system integrators to provide full compliance solutions in the areas of records management, legal discovery, storage, e-mail supervision, anti-money laundering, process integration, risk assessment, change
management, and controls.
The platform for many of these solutions is Oracle Collaboration Suite, which offers an adaptable platform to mitigate risk and strengthen corporate compliance by managing e-mail, electronic documents, instant messages, voice mail, fax, and Web conferences in a database repository. Organizations can take the first step toward establishing process controls across all content with a centralized repository to cost-effectively audit, retain, archive, and manage content for compliance—letting them react with agility when new regulatory pressures appear. For example, when an e-mail enters the system through the Oracle Collaboration Suite Email server, it will be flagged for retention if it matches server-side rules. Once the e-mail is retained, it will be classified with an indexing system,
where it can be queried using Oracle Ultra Search.
*Source: Transaction Processing Council (TPC) www.tpc.org. As of November 4, 2003. HP Integrity Superdome server running HP-UX 11i v2, HP StorageWorks solutions and Oracle Database 10g Enterprise Edition achieved 1,008,144.49 tpmC, at $8.33/tpmC, available April 14, 2004. For a complete list of the Top Ten TPC-C Results by Performance, see www.tpc.org/tpcc/results/tpcc_perf_results.asp.
|
Sample Code: One query for three object index sizes
This script provides a fast way to get the size of table segment, ordinary index segments, and Oracle Text (previously interMedia or Context) index for a given table in one single query. The Text index size was obtained by summing the Oracle-created DR$ table and index sizes.
select '&1' "Table", sum(tab_size) "Tab_Size (KB)",
sum(ind_size) "Ind_Size (KB)",
sum(text_size) "Text_Size (KB)",
sum(tab_size + ind_size + text_size) "Total (KB)"
from
(
select bytes/1024 tab_size, 0 ind_size, 0 text_size
from user_segments s
where s.segment_name = upper('&1')
UNION
select 0 tab_size, sum(bytes)/1024 ind_size, 0 text_size
from user_segments s, ind i
where s.segment_name = i.index_name
and i.table_name = upper('&1')
UNION
select 0 tab_size, 0 ind_size, sum(bytes)/1024 text_size
from user_segments
where segment_name in
(select table_name from tabs
where table_name like 'DR$'||
(select index_name from ind
where table_name = upper('&1')
and ityp_name = 'CONTEXT')||'$%'
union
select index_name from ind
where table_name like 'DR$'||
(select index_name from ind
where table_name = upper('&1')
and ityp_name = 'CONTEXT')||'$%'
)
);
XinJie Zhang ( xinjiezhang@yahoo.com) is a DBA with Sony Music Entertainment, Inc., in New York, New York.
CodeLocator
More code tips
otn.oracle.com/oramag/code
Sample code
otn.oracle.com/sample_code
|
| 
Bookmark
