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.

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..

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"

Oracle or Not

Should i work as an oracle developer or not?

ORA-01839 When Using Interval

I created a job that deletes 3 months past data.
During testing, i noticed that when using intervals, job fails in some days.

BEGIN
dbms_scheduler.create_job(
job_name        => 'purge_gps_archive_3_month',
job_type        => 'PLSQL_BLOCK',
job_action      => 'BEGIN delete from table_log where datetime_local<sysdate- interval "3" month; END;',
start_date=> to_date('28/07/2009 23:59','DD/MM/YYYY HH24:MI'),
repeat_interval => 'FREQ = DAILY; INTERVAL = 1',
enabled         => TRUE,
auto_drop       => FALSE,
comments        => 'This job deletes data from log table that are older than 3 months');
END;

After i use add_months instead of interval, problem solved.

BEGIN
dbms_scheduler.create_job(
job_name        => 'purge_gps_archive_3_month',
job_type        => 'PLSQL_BLOCK',
job_action      => 'BEGIN delete from table_log where datetime_local<add_months(sysdate,-3); END;',
start_date=""> to_date('28/07/2009 23:59','DD/MM/YYYY HH24:MI'),
repeat_interval => 'FREQ = DAILY; INTERVAL = 1',
enabled         => TRUE,
auto_drop       => FALSE,
comments        => 'This job deletes data from log table that are older than 3 months');
END;

Analytic 'First' and 'Last' Functions

When you need a value from the first or last row of a sorted group, but the needed value is not the sort key, the FIRST and LAST functions eliminate the need for self-joins or views and enable better performance.(quoted from tahiti)

http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/functions058.htm#sthref1414
http://www.psoug.org/reference/OLD/analytic_functions.html?PHPSESSID=26034dea1c0fb6e4ec0580b5f35f193f
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:12864646978683

Model Clause 1

Here are some links for model clause, first two are from tahiti.
After i read and understand them, i will share some interesting parts.

http://www.oracle.com/technology/obe/obe10gdb/bidw/sqlmodel/sqlmodel.htm


http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/sqlmodel.htm#sthref1869

http://www.oreillynet.com/pub/a/network/2004/08/10/MODELclause.html