Nehru Place IT Hub - PC compnents hub in Delhi/north India

Looks like an interesting site for pricing information/trends in Nehru Place IT Market.

Nehru Place IT Hub

Blogged with the Flock Browser

PC component prices in India...

Starting this collection of sites mentioning PC component prices in India -

TheITWares - Buy Computer Hardware , PC Components , Laptop Computers - One Stop for all Gizmos!!

PriceGuru Wiki / Intel Processors

Blogged with the Flock Browser

Gather statistics for a given oracle session

Gather statistics for a given oracle session

alter session set tracefile_identifier=''; 
-- should be replaced with your own identifying name...
alter session set events='10046 trace name context forever, level 8';
set timing on

PerlTips - 1

to escape particular characters in a given variable $var ->
$var =~ s/([CHARLIST])/\\$1/g;

(http://www.unix.org.ua/orelly/perl/cookbook/ch01_14.htm)

The complete Perl Bookshelf

http://www.unix.org.ua/orelly/perl/index.htm

Delete Statistics from a Schema

-- delete all statistics
DECLARE
CURSOR cOwner IS SELECT DISTINCT owner
               FROM dba_tables
                WHERE owner NOT IN ('SYS','SYSTEM','DBSNMP',);
BEGIN
 -- analyze sOwner,compute
 FOR rOwner IN cOwner LOOP
    DBMS_STATS.DELETE_SCHEMA_STATS
    (ownname => rOwner.owner);
 END LOOP;
END;
/
select 'END_DATE: '||to_char(sysdate,'dd.mm.yyyy hh24:mi:ss') as end_date from dual;
exit

Gather statistics for a schema

-- recreate all statistics
DECLARE
CURSOR cOwner IS SELECT DISTINCT owner
               FROM dba_tables
               WHERE owner NOT IN ('SYS','SYSTEM','DBSNMP',);
BEGIN
 -- analyze sOwner,compute
 FOR rOwner IN cOwner LOOP
    DBMS_STATS.GATHER_SCHEMA_STATS
    (ownname => rOwner.owner,
     estimate_percent => 99,
     block_sample => FALSE,
     method_opt => 'FOR ALL COLUMNS SIZE 150',
     degree => NULL,
     granularity => 'DEFAULT',
     cascade => TRUE);
 END LOOP;
END;
/

select 'END_DATE: '||to_char(sysdate,'dd.mm.yyyy hh24:mi:ss') as end_date from dual;
exit

Culture ambassador

Got two colleagues at home for tea, after office.

It was fascinating experience. The discussion was very interesting, my wife joined the discussion as well.

Somehow, it turned towards the culture and cuisine discussion. The thing is, with me and her together with europeans, it always happens, without fail. The discussions always tend to turn towards the people and the place.

We talked of various things, how is this particular dish prepared, hows that done. I think the understanding of people about Indian cuisine is spreading fast. People do know about it, and it amazes me as to how much do they know on their own. About spices, the way Indian fooding habits are, the reasoning of eating such food and all that.

Sometime, we feel that people like us, who travel away from their home and live in other countries for work etc, have another role to play other than being regular "foreginers" in that country. The very fact that we are from our native country there, bestows us with the responsibility of representing our country there.

I cant say whether or not we fulfilled that responsibility I just mentioned, but I feel that we should do that. Thats a much truer version of culture spreading to other lands, better than films, sponsored promotions, delegations etc.

Personally, I like talking about my culture, gives me a sound platform to tell them, "Guys, look at me. I am from India. A developing country, managed to do as much as you see in 50-60 years, which your western countries have been able to do in few hundred years." That sort of feeling makes me so proud, I love that.

Love India.