ICM Life Cycle!

START: Process control requests ->
Every X cycles, perform PMON ->
Every Y PMON’s, perform sizing ->
Sleep for Z seconds -> goto START
where
X = “PMON” parameter, which can be passed to the ICM as an argument or defaults to 4
Y = “QSIZE” parameter, which can be passed to the ICM as an argument or defaults to 1
Z = “Sleep” parameter, which is defined by the column FND_CONCURRENT_QUEUES.Sleep_Seconds

 

When to rebuild Index?

Select owner, index_name, blevel
From dba_indexes
Where blevel > 2;

Sql to get Shared Pool size

select  pool, to_number(v$parameter.value) value, v$sgastat.bytes, 
(v$sgastat.bytes/v$parameter.value)*100 percentfree
from  v$sgastat, v$parameter
where v$sgastat.name = ‘free memory’ and pool=’shared pool’
and v$parameter.name = ’shared_pool_size’;

Sql to find database,redo and temp size

select (select sum(bytes/1048576) from dba_data_files) “Data Mb”,
(select NVL(sum(bytes/1048576),0) from dba_temp_files) “Temp Mb”,
(select sum(bytes/1048576)*max(members) from v$log) “Redo Mb”,  3
(select sum(bytes/1048576) from dba_data_files) +
(select NVL(sum(bytes/1048576),0) from dba_temp_files) +
(select sum(bytes/1048576)*max(members) from v$log) “Total Mb”
from dual;

iPhone Review

The most talked about Gadget of 2007.I laid my hands on an iPhone imported from US as same is not yet officially launched in India. I used it for around 3 months and despite of the fact that it lacks some of the basic cell phone features like SMS forwarding, Stereo Bluetooth Support, Video Recording and ofcourse 3G, I found it to be one of the best phone I have used in recent times.Most of its shortcomings like SMS forwarding  and Video recording can be fixed with third party applications.

Here I am trying to capture my experience with an iPhone;

 

Display:
This is the best part of iPhone which puts it ahead of its competitors.A stunning 3.5 inches display with 480×320 pixel resolution (160 dots per inch).Its bright with great contrast and its sensitive too.Touch screen sensitivity is far better than any HTC touch screen phone with Windows OS.

Sometimes I wonder how can a company like Apple with its first ever cell phone comes up with such a great display where there are many Companies Like Samsung ,LG and others are doing full time R&D in this area.It reminds me of Steve jobs saying “Innovation has nothing to do with how many R&D dollars you have.When Apple came up with the Mac, IBM was spending at least 100 times more on R&D. It’s not about money. It’s about the people you have, how you’re led, and how much you get it.”

GUI:
Apple’s area of excellence.iPhone’s GUI is icing on the cake, very simple to use and intuitive.You will never feel lost or buried under the menus.Where ever you are, you always have a point of return to your home with just a single click .

Audio Quality:
This is the area where iPhone lacks the punch.I have never liked any iPod’s sound and iPhone is no different from ipod.For flat listening its ok but if you are a serious listener iPhone is not for you.
The worst part here is earphone, they are unable to reproduce the Low frequencies in addition to that they are very uncomfortable on the ears.

I tried Sony’s Walkman Series in-ear earphones with iPhone, ofcourse I had to screw up my Sony’s earphone connector pin (filing it) to made it fit into the iPhones hidden jack, but the whole exercise was worth doing as iPhone sounds great with these earphones.

To Find Processors Count

ioscan -fkn -C processor

To Find Apps Release Name

select apps.fnd_release.RELEASE_NAME from dual;