Thursday, December 31, 2009

Oracle Audits Us

I am now afraid to use some extra-cost features for testing purposes.
Oracle audits what features we have used in the database. You can query DBA_FEATURE_USAGE_STATISTICS view to see features you have used. DBA_HIGH_WATER_MARK_STATISTICS view shows max cpu count, maximum concurrent session count etc.

Monday, December 28, 2009

Reconfigure EM after changing hostname

Change listener.ora and tnsnames.ora if necessary,

Change etc\hosts file,


emca -deconfig dbcontrol db -repos drop

emca -config dbcontrol db -repos create


this is it..

Thursday, December 3, 2009

How To Delete a Service in Windows Server 2008

Deleting a windows service in Windows Server 2008 is so easy,
Just write text below on command prompt, of course change the "service name" part:

sc delete "service name"