OATS is a suite of applications that can be used for performance and scalability testing, functional and regression testing. It is a thin client application that runs within a web browser - so, it is easy to use the tool from anywhere as long as the web server running on the host node is accessible. Hopefully the following tips and tricks will benefit some of the users of the Oracle Application Testing Suite.Few technical details first - OATS is a 32-bit Java application that runs in a WebLogic container (WLS) with Oracle XE database being the...
Tuesday, 27 December 2011
Tuesday, 13 December 2011
Solaris Tip: Resolving "statd: cannot talk to statd at <target_host>, RPC: Timed out(5)"
Posted on 19:45 by Unknown
Symptom: System log shows a bunch of RPC timed out messages such as the following: Dec 13 09:23:23 gil08 last message repeated 1 timeDec 13 09:29:14 gil08 statd[19858]: [ID 766906 daemon.warning] statd: cannot talk to statd at ssc23, RPC: Timed out(5)Dec 13 09:35:05 gil08 last message repeated 1 timeDec 13 09:40:56 gil08 statd[19858]: [ID 766906 daemon.warning] statd: cannot talk to statd at ssc23, RPC: Timed out(5).. Those messages are the result of an apparent communication failure between the status daemons (statd) of both local and remote hosts...
Friday, 18 November 2011
Siebel Troubleshooting : An ODBC error occurred; SBL-GEN-03006: Error calling function: DICFindTable m_pReqTbl
Posted on 15:37 by Unknown
Symptom: A newly installed Siebel application server fails to start despite successful ODBC connectivity to the database. SRProc process logs ODBC error messages similar to the following: Message: GEN-13, Additional Message: dict-ERR-1109: Unable to read value from export file (Data length (32) > Column definition (3)).Message: GEN-13, Additional Message: dict-ERR-1107: Unable to read row 0 from export file (UTLDataValRead pBuf, col 4 ).GenericLog GenericError 1 0002157.. 11-11-18 13:28 Message: Generated SQL statement:, Additional...
Monday, 10 October 2011
Oracle Database on NFS : Resolving "ORA-27086: unable to lock file - already in use" Error
Posted on 17:45 by Unknown
Some Context Oracle database was hosted on ZFS Storage Appliance (NAS). The database files are accessible from the database server node via NFS mounted filesystems. Solaris 10 is the operating system on DB node. Someone forgets to shutdown the database instance and unmount the remote filesystems before rebooting the database server node. After the system boots up, Oracle RDBMS fails to bring up the database due to locked-out data files. eg., SQL> startupORACLE instance started.Total System Global Area 1.7108E+10 bytesFixed Size 2165208...
Thursday, 6 October 2011
Siebel Connection Broker Load Balancing Algorithm
Posted on 12:38 by Unknown
Siebel server architecture supports spawning multiple application object manager processes. The Siebel Connection Broker, SCBroker, tries to balance the load (incoming requests) across different object manager processes running in a single Siebel server. Least Loaded or Round Robin?By default, SCBroker forwards the incoming request to any object manager process that is least loaded - meaning the process with the least number of running tasks. In Siebel terminology, this behavior is referred as "least-loaded" or "LL" connection forwarding algorithm....
Saturday, 10 September 2011
Oracle RDBMS : Generic Large Object (LOB) Performance Guidelines
Posted on 22:11 by Unknown
This blog post is generic in nature and based on my recent experience with a content management system where securefile BLOBs are critical in storing and retrieving the checked in content. It is stro ngly suggested to check the official documentation in addition to these brief guidelines. In general, Oracle Database SecureFiles and Large Objects Developer's Guide 11g Release 2 (11.2) is a good starting point when creating tables involving SecureFiles and LOBs. GuidelinesTablespace: create the LOB in a different tablespace isolated from the rest...
Sunday, 28 August 2011
Oracle 11g: Travel back in time with the Database Flashback
Posted on 03:42 by Unknown
Error recovery, historical reporting, trend analysis, data forensics and fraud detection are just some of the business problems that can be solved by using the Flashback Data Archive feature in Oracle 11g database. The Flashback option can be enabled for the entire database or for a selected set of tables. It can be enabled in the database with no application changes.At work I usually run performance tests by starting with a clean copy of the database. I analyze the test results at the end of the test, determine the next course of action (tuning),...
Tuesday, 9 August 2011
Gene Kelly, the Man Who Can Dance
Posted on 21:19 by Unknown
I'm not a fan of musicals, and it is very unlikely I will ever be. However recently I developed interest in some of the oldies especially the ones starring Gene Kelly just for the sheer amount of entertainment value he brings to the screen. Michael Jackson is my only favorite entertainer all these years. Now Gene Kelly joins that élite with his graceful and magical dancing skills that majority of the current generation is unaware of. Here are my top 3 picks so far from Gene's performances. Sit back, relax and enjoy! (video courtesy: Google|YouTube)....
Saturday, 2 July 2011
Be Eco-Responsible. Use Resource Management features in Solaris, Oracle Database and Go Green
Posted on 00:53 by Unknown
This blog post is about a white paper that introduces the resource management features in Oracle Solaris and Oracle Database. Who needs more hardware when under-utilized systems are sitting idle in datacenters consuming valuable space, energy and polluting environment with carbon emissions. These days virtualization and con solidation are more popular than ever before. And then there is Oracle Corporation with great products consisting rich features for resource manageability in consolidated, virtualized and isolated envir onments. Put together...
Saturday, 28 May 2011
PeopleSoft Application Server : Binding JSL Port to Multiple IP Addresses
Posted on 01:11 by Unknown
For the impatient:On any multi-homed1 host, replace %PS_MACH% variable in "Jolt Listener" section of the application server domains' psappsrv.cfg file wih the special IP address "0.0.0.0" to get the desired effect. It enables TCP/IP stack to listen on all available network interfaces on the system. In other words, if JSL is listening on 0.0.0.0 on a multi-homed system, PIA traffic can flow using any of the IP addresses assigned to that system. For the rest: A little background first. PeopleSoft application server relies on Jolt, a companion product...
Tuesday, 24 May 2011
Oracle Database: How to Figure Out if a Tablespace is Empty
Posted on 00:52 by Unknown
It is not uncommon for Oracle DBAs to create, drop tablespaces for various reasons throughout the life of a database management system. It is a good practice to double check whether a tablespace is really empty before dropping it. One way is to visually check the "Tablespaces" section in Oracle Enterprise Manager (OEM) database console. However sometimes the graphical interface may return false positives. Another way is to rely on data dictionary views to obtain relevant information as accurately as possible. In the latter case, DBA_SEGMENTS /...
Tuesday, 12 April 2011
Oracle Solaris: Show Me the CPU, vCPU, Core Counts and the Socket-Core-vCPU Mapping
Posted on 00:40 by Unknown
[Replaced old code with new code on 10/03/11] It should be easy to find this information just by running an OS command. However for some reason it ain't the case as of today. The user must know few details about the underlying hardware and run multiple commands to figure out the exact number of physical processors, cores etc., For the benefit of our customers, here is a simple shell script that displays the number of physical processors, cores, virtual processors, cores per physical processor, number of hardware threads (vCPUs) per core and the...
Thursday, 10 March 2011
Sri Satyanarayana Vratamu in Telugu Script
Posted on 23:27 by Unknown
శ్రీ సత్యనారాయణ వ్రతము తెలుగులో. Part 1 : Vratakalpamu (వ్రతకల్పము)Part 2 : Kadha, Vishnu Sahasra Naamaavali (కధ, విష్ణు సహస్ర నామావళి) Download original documents and rotate counterclockwise for better readability. Courtesy/Publisher: గొల్లపూడి వీర సామీ సన్, రాజమండ్రి See Also:Hanuman Chalisa (హనుమాన్ చాలీసా) and Sandhya Vandanam (సంధ్యా వందనము) in Telugu Scr...
Tuesday, 1 February 2011
PeopleSoft Financials 9.0 (Day-in-the-Life) Benchmark on Oracle Sun
Posted on 20:43 by Unknown
It is very rare to see any vendor publishing a benchmark on competing products of their own let alone products that are 100% compatible with each other. Well, it happened at Oracle|Sun. M-series and T-series hardware was the subject of two similar / comparable benchmarks; and PeopleSoft Financials 9.0 DIL was the benchmarked workload. Benchmark report URLsPeopleSoft Financials 9.0 on Oracle's SPARC T3-1 ServerPeopleSoft Financials 9.0 on Oracle's Sun SPARC Enterprise M4000 Server Brief description of workload The benchmark workload simulated Financial...
Monday, 10 January 2011
Oracle 11g : Poor Performance Accessing V$SESSION_FIX_CONTROL
Posted on 19:07 by Unknown
PeopleSoft HCM, Financials/SCM 9.x customers may have to patch their Oracle database server with RDBMS patch 9699654. Rest of the Oracle customers: read the symptoms and decide. In couple of PeopleSoft deployments it is observed that the following SQL is the top query when all queries are sorted by elapsed time or CPU time. 11.2.0.1.0 is the Oracle database server version. SELECT VALUE FROM V$SESSION_FIX_CONTROL WHERE BUGNO = :B1 AND SESSION_ID = USERENV('SID') The target query is being executed thousands of times. The poor performance is due to...
Subscribe to:
Posts (Atom)
