A brief explanation of what an optimized solution is and what it is not can be found in the previous blog entry Oracle's Optimized Solution for PeopleSoft HCM 9.0. We went through a similar exercise to publish another optimized solution around Siebel CRM 8.1.1. The Siebel solution implements Oracle Siebel CRM using a unique combination of SPARC servers, Sun storage, Solaris OS virtualization, Oracle application middleware and Oracle database products. URLs to the Siebel CRM white papers: Optimized Solution for Siebel CRM 8.1.1 : A Technical White...
Saturday, 11 December 2010
According to Oracle Corporation: Oracle's optimized solutions are applications-to-disk solutions that are comprised of Oracle's Sun servers, storage, and networking components, Oracle Solaris, Oracle Enterprise Linux, Oracle Database, Oracle Fusion Middleware and Oracle Applications. To be clear, an optimized/optimal solution is neither a software package nor a hardware system bundled with pre-tuned software. It is simply a set of recommendations based on some testing performed in labs. The recommendations typically provide sizing guidelines for...
Thursday, 2 December 2010
The hardware prefetch is ON by default on M-series servers such as M8000/M9000, M4000/M5000, M3000 The following excerpt is from a SPARC64 document: Hardware speculatively issues the prefetch operation based on the prediction that there is high possibility to access to the following continuous address in the future, if there have been load accesses for a consecutive address. Although this feature is designed to improve the performance of various workloads, due to the speculative nature, not all workloads may benefit with the default behavior. For...
Tuesday, 30 November 2010
Windows users who have not interacted with any kind of UNIX or Linux distribution before are the target audience of this HOW-TO blog post. Download the latest version of Ubuntu 32-bit ISO image from the following location: http://www.ubuntu.com/getubuntu/download Burn the ISO image onto a CD or DVD so you can try running Ubuntu Linux from the CD (Live CD option) On the target system (running Windows...
Sunday, 31 October 2010
It's been mentioned and proved several times that Sun/Oracle's T-series hardware is the best fit to deploy and run Siebel CRM. Feel free to browse through the list of Siebel benchmarks that Sun published in the past on T-series: 2004-2010 : A Look Back at Sun Published Oracle Benchmarks Oracle Corporation announced the availability of SPARC T3 servers in Oracle OpenWorld 2010, and sure enough there is a Siebel CRM benchmark on SPARC T3-1 server to support the server launch event. Check the following...
Friday, 8 October 2010
(Even though the title explicitly states "Solaris Versus .. ", this blog entry is equally applicable to all the operating systems in the world with few changes.) Lately I have seen quite a few e-mails and heard few customer representatives talking about the performance of their application(s) on Solaris, Windows and Linux. Typically they go like the following with a bunch of supporting data (all numbers) and no hardware configuration specified whatsoever. "Transaction X is nearly twice as slow on Solaris compared to the same transaction running...
Thursday, 23 September 2010
The best practices slides from today's OpenWorld presentation can be downloaded from the following location. Siebel on Oracle Solaris : Best Practices, Tuning Tips The entire presentation with proper disclaimers and Oracle Solaris Cluster specific slides will be posted on Oracle's web site soon. Stay tun...
Monday, 9 August 2010
(Originally posted on blogs.sun.com at:http://blogs.sun.com/mandalika/entry/identifying_ideal_oracle_database_objects) The Sun Storage F5100 Flash Array and Sun Flash Accelerator F20 PCIe Card help accelerate I/O bound applications such as databases. The following are some of the guidelines to identify Oracle database objects that can benefit by using the flash storage. Even though the title explicitly states "Oracle", some of these guidelines are applicable to other databases and non-database products. Exercise discretion, evaluate and experiment...
Wednesday, 7 July 2010
(Original post is at:http://blogs.sun.com/mandalika/entry/peoplesoft_na_payroll_500k_ee) Few clarifications before we start. Difference between 240K and 500K EE PeopleSoft NA Payroll benchmarks Not too long ago Sun published PeopleSoft NA Payroll 240K EE benchmark results with 16 job streams and 8 job streams. First of all, I want to make sure everyone understands the fact that PeopleSoft NA Payroll 240K and 500K EE benchmarks are two completely...
Tuesday, 15 June 2010
(06/15/2010: This blog post will be edited multiple times to add reviews for the remaining chapters in the book.) Author: April C. SimsPublisher: PacktTarget Audience: Oracle Database Administrators Chapter #1 "When to step away from the keyboard" starts off with an interesting example, cautions the DBAs to be self-restraint but encourages to do the right thing at the end of the day. I liked the idea of listing out a whole bunch of graphical and command line Oracle tools [with brief descriptions] that an Oracle DBA may need in performing some of...
Monday, 31 May 2010
It is well known that the entire shared pool can be flushed with a simple ALTER SYSTEM statement. SQL> ALTER SYSTEM FLUSH SHARED_POOL;System altered. What if the execution plan of a single SQL statement has to be invalidated or flushed out of the shared pool so the subsequent query execution forces a hard parse on that SQL statement. Oracle 11g introduced a new procedure called PURGE in the DBMS_SHARED_POOL package to flush a specific object such as a cursor, package, sequence, trigger, .. out of the object library cache. The syntax for the...
Sunday, 23 May 2010
(Original post is at blogs.sun.com at:http://blogs.sun.com/mandalika/entry/oracle_database_say_i_no) .. unless you are working with a database that is largely read-only or if the new index is supposed to be fixing a critical performance issue with no side effect(s).Two topics covered in this blog entry with plenty of simple examples: Why creating new indexes on a heavily modified table may not be a good idea? and How to identify unused indexes?Read on.Indexes are double-edged swords that may improve the performance of targeted queries, but in some...
Monday, 10 May 2010
(Originally posted on 12/09/2009. This blog posted will be updated as new compositions come along.)For the past couple of weeks I have had fun playing with Apple's GarageBand. It is a nice piece of software with intuitive user interface and tons of free & ready-to-use music loops. It only took a couple of tries and about 6 hours to produce my first ever mixed tune with software of any kind. The second one just took two hours as my main focus...
Friday, 7 May 2010
Monday, 3 May 2010
(Originally posted on blogs.sun.com at http://blogs.sun.com/mandalika/entry/oracle_11g_r1_poor_data)Symptom(s)Data Pump Export utility, expdp, performs well with non-partitioned tables, but exhibits extreme poor performance when exporting objects from a partitioned table of similar size. In some cases the degradation can be as high as 3X or worse.SQL traces may show that much of the time is being spent in a SQL statement that is similar to:UPDATE "schema"."TABLE" mtu SET mtu.base_process_order = NVL((SELECT mts1.process_order FROM "schema"."TABLE"...
Wednesday, 21 April 2010
(Originally published on blogs.sun.com at:http://blogs.sun.com/mandalika/entry/2004_2010_a_look_back)tr.year td { color: #008000; font-family: georgia; font-size: 125%; } tr.even td { background-color: #E0E0E0; color: black; font-family: arial; font-size: 90%; } tr.odd td { background-color: #E6E6FA; color: black; font-family: sans-serif; font-size: 90%; } p, ul { font-family: georgia,garamond,sans-serif; } Since Sun Microsystems became a legacy, I got this idea of a reminiscent [farewell] blog post for the company that gave me the much needed...
Monday, 1 March 2010
tbody.itable { font-family: verdana,times,georgia,garamond,arial; font-size: small}Oracle|Sun published PeopleSoft Campus Solutions 9.0 benchmark results on February 18, 2010. Here is the direct URL to the benchmark results white paper: PeopleSoft Enterprise Campus Solutions 9.0 using Oracle 11g on a Sun SPARC Enterprise M4000 & Sun Blade X6270 ModulesSun published three PeopleSoft benchmarks on SPARC platform over the last 12 month period -- one OLTP and two batch benchmarks[1]. The latest benchmark is somewhat...
Thursday, 11 February 2010
Case in hand: Given a PeopleSoft Data Mover exported data file (db or dat file), how to extract the DDL statements [from that data file] which gets executed as part of the Data Mover's data import process?Here is a quick way to do it: Insert the SET EXTRACT statements in the Data Mover script (DMS) before the IMPORT .. statement.eg.,% cat /tmp/retrieveddl.dms..SET EXTRACT OUTPUT /tmp/ddl_stmts.log;SET EXTRACT DDL;..IMPORT *;It is mandatory that the SET EXTRACT OUPUT statement must appear before any SET EXTRACT statements. Run the Data Mover utility...
Subscribe to:
Posts (Atom)
