Author Archives: Osama Magdy

Temporary Tablespace in Oracle 10g

Posted on October 31, 2010 by Osama Magdy

Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory, space will be allocated in a temporary … Continue reading →

Posted in Uncategorized | Tagged , | Leave a comment

How to connect to a specific SID using sqlplus under Unix

Posted on August 5, 2010 by Osama Magdy

A very easy way to connect to a specific SID (other than the default one) using sqlplus, is to make this SID “temporarily” the default SID. Just change ORACLE_SID environment variable to the required SID name: export ORACLE_SID=sid_name Then connect … Continue reading →

Posted in Uncategorized | Tagged | 1 Comment

My CRM Session @FCIH Intiatave Program

Posted on August 1, 2010 by Osama Magdy

Last Wednesday, I’ve delivered a session about CRM “Customer Relationship Management” in my dear faculty “Faculty of Computers and Information – Helwan University” 🙂 Many many thanks to the organizers, and whoever made efforts to make this day successful. And … Continue reading →

Posted in Uncategorized | Tagged , , , , | Leave a comment

How to uncompress zip file on AIX

Posted on May 4, 2010 by Osama Magdy

To uncompress a zip file on AIX, use “unzip“ command: unzip file_name.zip

Posted in Uncategorized | Tagged | Leave a comment

How to run a script in startup

Posted on August 19, 2009 by Osama Magdy

I needed this feature to run a “read-only” mount for windows file system on startup (because I always hibernate Windows, so Ubuntu can’t mount it “read-write” by default on startup) 1- Write the script in a file and save it … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment