Friday, September 5, 2014

Sencha Touch 2 - View and Controller Basics

Javascript: Introduction to Anonymous functions

Anonymous functions are functions that are dynamically declared at runtime that don’t have to be given a name.

Anonymous functions are declared using the function operator. You can use the function operator to create a new function wherever it’s valid to put an expression. For example you could declare a new function as a parameter to a function call or to assign a property of another object.

Example of a non-anonymous function:
function dosomething(){

    var b = 3;
    a += b;
    return a;

Monday, April 8, 2013


What is that GOOGLE NOSE? 

Google NoseBETA leverages new and existing technologies to offers Android Ambient Odor Detection technology, collects smells via the world's most sensible mobile operating system.
SMELLCD™ 1.8+ high-resolution compatible for precise and controlled odors.

Official Video :

Source  : google

In its latest April Fool 2013 prank, Google claims the ability to search for smells! According to Google, the Nose BETA leverages new and existing technologies to offer the sharpest olfactory experience available. According to Google, the search engine now has a data base of 15 million smells!  

Wasn't that a good prank? :)

Tuesday, July 10, 2012

Reload / Refresh Page in jQuery

Here is the code to refresh the page when u click on a button component. Its just like you press "F5" button to refresh page.
=======================Code begins =========================
<!doctype html>
<html lang="en-us">
<title>Reload/Refresh a Page in jQuery</title>
<script type="text/javascript" src=""> </script>

<script type="text/javascript">
$(document).ready(function() {
$('#Refresh').click(function() {
$("p").append("<strong>Now Refreshing page..</strong>");

Thursday, June 28, 2012

Oracle DBA script: Monitor user activity on the DB

Code :

set linesize 80
set verify off message off echo off pause off timing off time off
set feedback off
column o format a8 heading 'O/S|User'
column u format a10 heading 'Oracle|Userid'
column s format a12 heading 'R-S|Name'
column txt format a45 heading 'Current Statement' word

Oracle DBA script: Display hit ratio on Dictionary Cache

Increase Shared pool size to reach a 90% hit ratio on Dictionary Cache. Entries for dc_table_grants, d_user_grants, and dc_users should be under 5% each in the MISS RATE % column

parameter,gets,Getmisses ,
getmisses/(gets+getmisses)*100 "miss ratio",
(1-(sum(getmisses)/ (sum(gets)+sum(getmisses))))*100 "Hit ratio"
from v$rowcache
where gets+getmisses <>0
group by parameter, gets, getmisses ;

Oracle DBA script: tablespace usage in %, blocks used etc

Code :
SELECT RPAD(,18,' ') tablespace ,
LPAD(TO_CHAR(CEIL( (SUM(s.blocks)*COUNT(*)) / (SUM(f.blocks) *
POWER(COUNT(DISTINCT(f.file#)),2)) * 100 )),3) Pct ,
LPAD(TO_CHAR(TRUNC(SUM(f.blocks) * t.blocksize *
COUNT(DISTINCT(f.file#)) /
( COUNT(*) * 1024 * 1024 * 1024 ),2)),6) vol_G ,
LPAD(TO_CHAR(SUM(f.blocks) * t.blocksize * COUNT(DISTINCT(f.file#)) /
( COUNT(*) * 1024 * 1024 )),8) volume_M ,
TRUNC(SUM(s.blocks) * t.blocksize /
( 1024 * 1024 * COUNT(DISTINCT(f.file#))),2) taken_M ,
TRUNC( ( SUM(f.blocks) * t.blocksize * COUNT(DISTINCT(f.file#))
/ ( COUNT(*) * 1024 * 1024 ) )
- ( NVL(suM(s.blocks),0) * t.blocksize
/ ( 1024 * 1024 * COUNT(DISTINCT(f.file#)) ) ),2) remain_M
FROM sys.seg$ s, sys.ts$ t, sys.file$ f
WHERE s.ts# (+) = t.ts#
AND f.ts# = t.ts#
AND f.status$ = 2
GROUP BY, t.blocksize

Oracle DBA script: Display Quota Allocated


select * from DBA_TS_QUOTAS
order by Tablespace_Name, Username;

Oracle DBA script: List the UGA and PGA used by each session

column name format a25
column total format 999 heading 'Cnt'
column bytes format 9999,999,999 heading 'Total Bytes'
column avg format 99,999,999 heading 'Avg Bytes'
column min format 99,999,999 heading 'Min Bytes'
column max format 9999,999,999 heading 'Max Bytes'
ttitle 'PGA = dedicated server processes - UGA = Client machine process'

compute sum of minmem on report
compute sum of maxmem on report
break on report

select se.sid,, 
max(se.value) maxmem
from v$sesstat se,
v$statname n
where n.statistic# = se.statistic#
and in ('session pga memory','session pga memory max',
'session uga memory','session uga memory max')
group by,se.sid
order by 3

Oracle DBA Script : Monitor and veryfy deadlocks

Monitor and Verify DEAD Locks: Holding and Waiting Sessions


set lines 80 echo on ver off timing on term on pages 60 feed on head on

col " " for A25
col "Holding Session Info" for A25
col "Waiting Session Info" for A25