By Johannes (User) on
3/18/2009 4:09 AM
By Johannes Ahrends and John Pocknell
In the previous blog, we compared and contrasted how database Performance Management operations are performed in Oracle’s Enterprise Manager (OEM) and Quest’s Toad DBA Suite for Oracle and how Toad is an excellent complement to OEM because it simplifies and automates many tasks which would...
|
By Johannes (User) on
3/2/2009 6:04 AM
By Johannes Ahrends and John Pocknell
In the previous blog, we compared and contrasted how Database Maintenance operations are performed in Oracle’s Enterprise Manager (OEM) and Quest’s Toad DBA Suite for Oracle and how Toad is an excellent complement to OEM because it simplifies and automates many tasks which would take longer in OEM. ...
|
By Johannes (User) on
2/3/2009 9:36 AM
By Johannes Ahrends and John Pocknell
This 3-part blog will help you differentiate between what Oracle Enterprise Manager (OEM) offers the DBA compared to Toad DBA Suite for Oracle and how the same tasks are approached using each.
Toad DBA Suite for Oracle provides a complete solution for DBAs using Oracle Standard Edition, or in smaller shops where OEM is not being used or as a complementary solution for...
|
By Johannes (User) on
1/8/2009 8:56 AM
Is German your native language? Read this blog in German on Johannes' tech articles page.
Since version 10g, Oracle provides a new job scheduling mechanism named scheduler. There are several advantages over the old dbms_job function but as often the documentation and the various functions is more confusing than helpful. In 11g...
|
By Johannes (User) on
1/7/2009 12:51 PM
Is German your native language? Read this blog in German on Johannes' tech articles page.
A lot of companies with Oracle databases have been using RMAN as their main backup utility for years now. But others are still relying on the classical way by copying data files or even using Oracle export as a backup method. There are several reasons for this,...
|
By Johannes (User) on
11/3/2008 9:24 AM
Migrating to a database that supports Unicode is a challenge. You are safe if you are currently using US7ASCII for you Oracle database because Oracle provides a mechanism with ALTER DATABASE SET CHARACTERSET UTF8 which allows you by just bouncing the database to switch to this new character set. But what if you are currently on a different character set? In Europe we have a bunch of WE8 (Western European) or EE8 (Eastern European) character sets and as they are not a strict subset of Unicode the ALTER Database does not work. So the only chance is to export the whole database, create a new one (with UTF8 or similar) and import it again. ...
|