Oracle 10g enqueue waits descriptions

Here is a nice blog regarding oracle 10g enqueue waits, http://venzi.wordpress.com/2009/05/08/oracle-10g-enqueue-waits/

How TO: change the sql server service account

This internet link, show how you can changed the SQL Server service account without using SQL entereprise Manager, it can also helps you if you want to troubleshoot any problem once you changed the SQL server service account .


HOW TO: Change the SQL Server Service Account Without Using SQL Enterprise Manager in SQL Server 2000
http://www.myitforum.com/articles/18/view.asp?id=6724

Oracle 10g materialized view bug, when using import fromuser , touser. ORA-00942

If you have materialized view, and importing using the option fromuser and touser , you may have the error below :-

BEGIN
dbms_mview.refresh('MV_TEST','C');
END;
*ERROR at line 1:ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2429ORA-06512: at line 1

This is a bug in the oracle 10g, to workaround this recreate the materialized view.

SQL 2000, ANSI_DEFAULTS, ANSI NULL settings

Recently, i have the problem of a query  in a sp comparing null values and is unable to return values..

After going through this, found out that if a sp is created in query analyzer with null values setting is set to ANSI_NULL is set to on , the sp itself when run by user will take this settings.

"It is slightly more complicated to resolve ANSI_NULL problems when dealing with stored procedures, triggers and views as the ANSI_NULLS setting is saved when these objects are created or altered and is enabled (used) upon their execution. In other words, these objects inherit the ANSI settings of the user session that is used to creates them."

This is explain by the url below.

Understanding the Implications of ANSI SQL92 SET Options

http://www.sqlservercentral.com/articles/Administration/understandingtheimplicationsofansisql92setoptions/482/

SQL server database backup - Important to check the backup policy

Recently , we have a sql server data corruption that needed the backup to be restored. We have two scheduled backup , 1 is to a backup disk and the other one is to the backup tape.

After checking the backups, found out that the only usable restoration is by using the backup tape. This is because the task to backup to tape reinitialized the transaction log , this caused the folder backup cannot be restored to point in time.

The point is, Make sure that if there are two backup policy ensure that both of them didn't clear the other one backup transaction log.

Apache Slow performance with NFS mount

Recently we have a slow performance with our web site after we redirect our OC4J Application logs to the NFS mount, which is using servlet to logs the application log.

Metalink :

Log Directories In NFS Mounted Device Environment Causes Performance Problem With Apache , Note: 180522.1

Bad performance of Apache when filesystem is NFS mounted, Note : 467315.1

Import DataPump : Error after importing PLS-00103 - compilation error

If you encounter error PLS-00103 while using import data pump to import data pump data into a new database with Oracle 10g but dont have problem if using the import and export utility . (imp/exp) .

Then most probably you encounter the bug in oracle 10g. If the source package/procedure... is wrapped and uses mulitbyte character set when using the import data pump, it add extra line behind the wrap.

To workaround this , 1)use the imp/exp tools. 2) manually edit the source code to removed the extra lines. 3) Find and get the bug fixed patch in the metalink.

Impdp Returns ORA-39082 When Importing Wrapped Procedures
Metalink Note :- 460267.1