select dbms_flashback.get_system_change_number
from dual
/

Posted in Oracle No Comments »

Table fragmentation can have a severe impact on performance. the query below will list the tables with chained rows for all scemas. It is recommend that chained rows are eliminated on a regular basis.
select owner, table_name, chain_cnt “CHAINED_ROWS”,
[…]

Posted in Oracle No Comments »

I came across a posting on a website that I had to share. Thing is, I recognised it and I’m sure everyone reading this will have recognised the same in their time. It is an article on the ‘New Man’. I won’t describe it, as it will take away from you reading the […]

Posted in Slightly Humorous, General 1 Comment »