The 80s contd., The 80s witnessed the rise of fine talent - so, it is only fitting to dedicate another complete playlist for the 80s. Here it is. Enjoy. Earlier playlists can be accessed from the following locations: Blast from the Past : The Weekend Playlist #2 (80s) Blast from the Past : The Weekend Playlist #1 (50s, 60s and 70s) Audio-Visual material courtesy: YouTube 1. Aerosmith - Dude (Looks Like a Lady) (1987) Featured in Robin Williams' Mrs. Doubtfire. 2. Kool & the Gang - Celebration...
Saturday, 28 December 2013
Saturday, 21 December 2013
.rndcorner { width:37%; border:1px solid #a1a1a1; padding:10px 40px; border-radius:25px; } iperf is a simple, open source tool to measure the network bandwidth. It can test TCP or UDP throughput. Tools like iperf are useful to check the performance of a network real quick, by comparing the achieved bandwidth with the expectation. The example in this blog post is from a Solaris system, but the instructions and testing methodology are applicable on all supported platforms including Linux. Download the source code from iperf's home page, and...
Saturday, 7 December 2013
The 80s The quality of music steadily improved over the decades in mid-1900s, and eventually peaked in the 80s. Some may disagree, but in my opinion, the 80s were easily one of the best decades for music in the United States. The decade witnessed the emergence of many successful artists who delivered solid hits, that are still relevant and part of many pop culture references today. The launch of MTV in 1981 upped the ante to produce interesting videos in an effort to increase the global outreach. In this iteration, let's focus on the decade of...
Saturday, 30 November 2013
Very basic and generic discussion from the performance point of view. Customers still have to do their due diligence in understanding redo logs, and how they work in Oracle database, before finalizing redo log configuration for their deployments. size them properly log writer writes to a single redo log file until either it is full or a manual log switch is requested Oracle supports multiplexed redo logs for availability, but this behavior of writing to a file until it is full or a log switch...
Sunday, 17 November 2013
Music and Movies - the two powerful forms of entertainment, are very subjective. In general, there is no good or bad music, and there are no good or bad movies. Their success depend on a combination of various factors such as the mood we are in, our biases, memories, brand (eg., Pixar in movies; The Beatles in music, although I never came across any palatable original work from this boy-band group), derivation from other successful work -- remixes (Fatboy Slim), mashups (DJs), mockery (spoof movies, comedy skits), influence/herd mentality (Bieber,...
Tuesday, 15 October 2013
.roundedcorner { width:75%; border:1px solid #a1a1a1; padding:10px 40px; border-radius:25px; } Goal: for a given process, find out how the SGA was allocated in different locality groups on a system running Solaris operating system. Download the shell script, sga_in_lgrp.sh. The script accepts any Oracle database process id as input, and prints out the memory allocated in each locality group. Usage: ./sga_in_lgrp.sh <pid> eg., # prstat -p 12820 PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP 12820 oracle 32G...
Monday, 30 September 2013
[Solaris] Cleanup all IPC resources Run the following wrapper script with root user privileges. for i in `ipcs -a | awk '{ print $2 }'`do ipcrm -m $i 2> /dev/null ipcrm -q $i 2> /dev/null ipcrm -s $i 2> /dev/nulldone [Java, WebLogic] Find the process id (pid) of a WebLogic managed server instance Run the following as the user who owns the process, or with root user privileges. /usr/java/bin/jps -v | grep <WLS_server_name> | awk '{ print $1 }' I think this tip is applicable on all supported platforms. eg.,Finding the pid of a managed...
Saturday, 31 August 2013
.fader { color: #000000; margin: 0.5em 0; padding: 0.5em 1em; background: -moz-linear-gradient(to right, #E8E8E8, #fff); } .fadel { color: #000000; margin: 0.5em 0; padding: 0.5em 1em; background: -moz-linear-gradient(top right, #E8E8E8, #fff); } (1) AWR report shows bogus wait events and times on SPARC T5 servers Here is a sample from one of the Oracle 11g R2 databases running on a SPARC T5 server with Solaris 11.1 SRU 7.5 Top 5 Timed Foreground Events EventWaitsTime(s)Avg wait (ms)% DB timeWait...
Tuesday, 30 July 2013
1. [Re]compiling all objects in a schema exec DBMS_UTILITY.compile_schema(schema => 'SCHEMA'); To recompile only the invalid objects in parallel: exec UTL_RECOMP.recomp_parallel(<NUM_PARALLEL_THREADS>, 'SCHEMA'); A NULL value for SCHEMA recompiles all invalid objects in the database. 2. SGA breakdown in Solaris Locality Groups (lgroup) To find the breakdown, execute pmap -L | grep shm. Then separate the lines that are related to each locality group and sum up the value in 2nd column to arrive at a number that shows the total SGA...
Sunday, 30 June 2013
.roundedcorner { border:1px solid #a1a1a1; padding:10px 40px; border-radius:25px; } .boxshadow { padding:10px 40px; box-shadow: 10px 10px 5px #888888; } 1. Most Oracle software installers need assembler Assembler (as) is not installed by default on Solaris 11. Find and install eg., # pkg search assemblerINDEX ACTION VALUE PACKAGEpkg.fmri set solaris/developer/assembler pkg:/developer/assembler@0.5.11-0.175.1.5.0.3.0# pkg install pkg:/developer/assembler Assembler binary...
Friday, 31 May 2013
SUMMARY System Under Test (SUT) Oracle's SPARC T5-2 server Software Oracle Internet Directory 11gR1-PS6 Target Load 50 million user entries Reference URL OID/T5 benchmark white paper Oracle Internet Directory (OID) is an LDAP v3 Directory Server that has multi-threaded, multi-process, multi-instance process architecture with Oracle database as the directory store. BENCHMARK WORKLOAD DESCRIPTION Five test scenarios were executed in this benchmark - each...
Friday, 12 April 2013
Hardly six months after announcing Siebel 8.1.1.4 benchmark results on Oracle SPARC T4 servers, we have a brand new set of Siebel 8.1.1.4 benchmark results on Oracle SPARC T5 servers. There are no updates to the Siebel benchmark kit in the last couple years - so, we continued to use the Siebel 8.1.1.4 benchmark workload to measure the performance of Siebel Financial Services Call Center and Order Management business transactions on the recently announced SPARC T5 servers. Benchmark Details The latest Siebel 8.1.1.4 benchmark was executed on a mix...
Tuesday, 5 March 2013
To be clear, this post is about a white paper that's been out there for more than two months. Access it through the following url. Best Practices for Deploying Oracle Solaris Zones with Oracle Database 11g on SPARC SuperCluster The focus of the paper is on databases and zones. On SuperCluster, customers have the choice of running their databases in logical domains that are dedicated to running Oracle Database 11g R2. With exclusive access to Exadata Storage Servers, those domains are aptly called "Database" domains. If the requirement...
Tuesday, 12 February 2013
Just like the Siebel 8.1.x/SPARC T4 benchmark post, this one too was overdue for at least four months. In any case, I hope the Oracle BI customers already knew about the OBIEE 11g/SPARC T4 benchmark effort. In here I will try to provide few additional / interesting details that aren't covered in the following Oracle PR that was posted on oracle.com on 09/30/2012. SPARC T4 Server Delivers Outstanding Performance on Oracle Business Intelligence Enterprise Edition 11g Benchmark Details System Under TestThe entire BI middleware...
Sunday, 3 February 2013
It is one of the hot topics among Galaxy S II users. In web forums, some of the recurring solutions appear to be rooting the phone or muting the "system" sounds. They seem to work in some cases. However there is a much simpler solution for Galaxy S II phones running Ice Cream Sandwich (ICS) version of Android. Steps: Launch the Camera application Tap the Menu key button to bring up "Edit Shortcuts" menu Tap "Edit Shortcuts" menu item to list out...
Wednesday, 30 January 2013
Siebel is a multi-threaded native application that performs well on Oracle's T-series SPARC hardware. We have several versions of Siebel benchmarks published on previous generation T-series servers ranging from Sun Fire T2000 to Oracle SPARC T3-4. So, it is natural to see that tradition extended to the current genration SPARC T4 as well. Benchmark Details29,000 user Siebel 8.1.1.4 benchmark on a mix of SPARC T4-1 and T4-2 servers was announced during the Oracle OpenWorld 2012 event. In this benchmark, Siebel application server instances ran on...
Subscribe to:
Posts (Atom)
