Gauri Shiv Enterprises

How to install MySQL using Source Distribution on Linux:

After MySQL configuration, when you try to restart your mysql service with this command /etc/rc.d/init.d/mysql start, and after this you get error  message

"ERROR! Manager of pid-file quit without updating file."

When you try to access phpmyadmin with link http://localhost/phpmyadmin, if you get “Cannot load mcrypt extension. Please check your PHP configuration.” error message every browsing web page of phpmyadmin .

When you try to access phpmyadmin with link http://localhost/phpmyadmin, if you get this error “The configuration file now needs a secret passphrase(blowfish_secret).” message on browsing window.

Hi All,

I am starting a blog for the Knowledge sharing about ASM (Automatic Storage Management). It may include New Features Installation,configuration,upgradation of ASM, Patching, Compatibility With RAC etc. Please avoid  repetion

  SCN can refer to:

    System Change Number - A number, internal to Oracle that is incremented over time as change vectors  
                           are generated, applied, and written to the Redo log.

  While user is issuing DML transaction the  redo entrie for this transaction Is store to the buffer in to SGA. And  after commit issue redo data written to the  redo log file  which physical located on  hard disk. This is normal practice and it is called synchronous Commit.  Oracle does not return control until the transaction physically written.

But this practice not very much acceptable for  high speed Transition.   this point of view oracle introduce Asynchronous commit  in 10g release 2.

Query Optimizer A sql statement can be executed in many different ways such as full table scans,index scans,nested loops and hash joins.