Not My Day

Apparently this is not my day . started having issues with blogger thought lets just switch to the beta it looks cool. and probably bombarded people with all my old posts. I was look at Orana and saw all my old posts appear again. Blogger needs to put that as a disclaimer as it might have caused a lot of grief to people Sorry Eddie.

Not My Day

Apparently this is not my day . started having issues with blogger thought lets just switch to the beta it looks cool. and probably bombarded people with all my old posts. I was look at Orana and saw all my old posts appear again. Blogger needs to put that as a disclaimer as it might have caused a lot of grief to people Sorry Eddie.

Pythian Group Blog » Oracle block corruptions, DBV vs RMAN

Wow, What a coincedence . i just had to deal with this 2 days ago. so i was very surprised when i saw this post from paul of pythian on the subject .
Also i’m very annoyed with the dissappearene of the blog this button anf the appearence of the send to blogger button . it just isnt the same
Pythian Group Blog » Oracle block corruptions, DBV vs RMAN: “
Edit :Well the fact that Blogger is behaving so weirdly today is causing me grief with even posting stuff.

Pythian Group Blog » Oracle block corruptions, DBV vs RMAN

Wow, What a coincedence . i just had to deal with this 2 days ago. so i was very surprised when i saw this post from paul of pythian on the subject .
Also i’m very annoyed with the dissappearene of the blog this button anf the appearence of the send to blogger button . it just isnt the same
Pythian Group Blog » Oracle block corruptions, DBV vs RMAN: “
Edit :Well the fact that Blogger is behaving so weirdly today is causing me grief with even posting stuff.

Oracle Stuff I should have known !: If Only …

Read through Tom Kytes Blog i came through this post.
Very Well written and the fact that we’ve been trying to get our developers to do the same thing .
if only developers understood how valuable it is too them and to the whole architecture of the project .
These days most projects are dump and run .
which in turn causes a lot of grief to the assicated parties
Oracle Stuff I should have known !: If Only …:
I’ve also added a link to Tom’s Followup on dbms_application_info which describes information in 10G about program id and line number ofthe pl/sql code.
Makes life much easier and a database more manageable.
http://tkyte.blogspot.com/2006/09/action-module-program-id-and-vsql.html

Oracle Stuff I should have known !: If Only …

Read through Tom Kytes Blog i came through this post.
Very Well written and the fact that we’ve been trying to get our developers to do the same thing .
if only developers understood how valuable it is too them and to the whole architecture of the project .
These days most projects are dump and run .
which in turn causes a lot of grief to the assicated parties
Oracle Stuff I should have known !: If Only …:
I’ve also added a link to Tom’s Followup on dbms_application_info which describes information in 10G about program id and line number ofthe pl/sql code.
Makes life much easier and a database more manageable.
http://tkyte.blogspot.com/2006/09/action-module-program-id-and-vsql.html

Ubuntu

Lewis Cunningham has a post titled Kubuntu and Upgrades all Around.
Considering i just hit the ubuntu bandwagon by upgrading my spare windows workstation and installing Oracle Xe . I was very surprised at the look and feel . Although i heard a lot of people dont like the fact that root is locked out by defauly and you have to sudo to do everything. i would say that is the way to go. if i need root i can always unlock it or better yet learn to use sudo more often and make a good secure lifestyle.
Anyways ubuntu looks to me like a stable and to go for distro for home and office so i might take the leap and get it to work at home one of these days

Ubuntu

Lewis Cunningham has a post titled Kubuntu and Upgrades all Around.
Considering i just hit the ubuntu bandwagon by upgrading my spare windows workstation and installing Oracle Xe . I was very surprised at the look and feel . Although i heard a lot of people dont like the fact that root is locked out by defauly and you have to sudo to do everything. i would say that is the way to go. if i need root i can always unlock it or better yet learn to use sudo more often and make a good secure lifestyle.
Anyways ubuntu looks to me like a stable and to go for distro for home and office so i might take the leap and get it to work at home one of these days

Active Session History

I was hit yesterday with a question . How do we know if someone executes a query or a system call.
since i’ve not been using 1-g that often. idecided to dig into ash and see all the data the oracle collects.
it was a interesting experience but i still found that oracle misses somestuff maybe becuase i was looking at wrh$_active_session_history which i’m not sure how prunes out what to keep and what not.
but i found some ‘alter system’ and ‘alter session’ commands from dba_hist_sqltext and i’ didnt find some,
this seemed like a problem. i know the alter system happened since the alert log has a record.
i’ll update this post as i find more and maybe someone can comment on this is they have found descrapancies and what and how to secure a system and find out if someone has stolen the sys/system password or just a bad judegement call from the dba’s end .
lutz hartmann this week: Active Session History in Oracle 10gR1+2

Active Session History

I was hit yesterday with a question . How do we know if someone executes a query or a system call.
since i’ve not been using 1-g that often. idecided to dig into ash and see all the data the oracle collects.
it was a interesting experience but i still found that oracle misses somestuff maybe becuase i was looking at wrh$_active_session_history which i’m not sure how prunes out what to keep and what not.
but i found some ‘alter system’ and ‘alter session’ commands from dba_hist_sqltext and i’ didnt find some,
this seemed like a problem. i know the alter system happened since the alert log has a record.
i’ll update this post as i find more and maybe someone can comment on this is they have found descrapancies and what and how to secure a system and find out if someone has stolen the sys/system password or just a bad judegement call from the dba’s end .
lutz hartmann this week: Active Session History in Oracle 10gR1+2