Tuesday, July 15, 2014

What is the difference between the columns PID and SPID in v$process?

›
The PID column is an internal counter that oracle uses for its own processes. It is incremented by one for every new process. Consequently, ...

More on the TO_DSINTERVAL conversion function

›
The TO_DSINTERVAL function is very flexible. All you need to do is to specify the interval you're looking for, and it will convert your...
Thursday, July 10, 2014

A convenient way to declare variables in PL/SQL

›
In PL/SQL programming, a convenient (and programmatically safe) way to specify data types for your variables is to let them be inherited fro...

How to drop stuck purge job created through DBMS_AUDIT_MGMT

›
In the process of implementing automatic purging of the audit trail, I came across a problem that I was really puzzled by: In the debugging...
2 comments:
Tuesday, July 8, 2014

How to purge the log entries for a specific dbms_scheduler job

›
exec dbms_scheduler.purge_log(log_history=>0, job_name=>'YOUR_JOB_NAME'); Zero is actually default for log_history, it doesn...
Wednesday, July 2, 2014

How to work around ORA-01830: date format picture ends before converting entire input string

›
When querying a column of type TIMESTAMP WITH TIMEZONE, I wanted to omit the fractional seconds + the time zone information. The query ...
Tuesday, July 1, 2014

How to print the database incarnations from V$DATABASE_INCARNATION using an hierarchical query

›
I just realized that V$DATABASE_INCARNATION is a perfect candidate for using hierarchical queries for formatting. Let's start with cur...