Latest Articles
GNU Screen Handbook
#linuxGNU Screen is a very useful tool to run a long script on a server and make sure the script will run even if your computer gets disconnected, runs out of battery or whatever. In this article, I’ll ... Read more
20 Oct 2015 - less than 1 minute readMySQL partial import
#mysql #importHere’s the situation. You have a dumpfile called mysql.dmp which contains a whole MySQL database dump. However you only need to import one table (or anything, but only a portion of that dumpfile). ... Read more
20 Sep 2015 - less than 1 minute readSQL*Net more data from client
#oracle #networkThe error SQLNet more data from client* usually happens when there’s a large amount of data sent from client (or other database in case of dblinks), which doesn’t fit into single SDU size Oracle pa... Read more
20 Aug 2015 - 1 minute readArchive log files based on date
#linuxHere’s some piece of code to use on a cron job when you have a software component (database or application) that spits out logs and you want to archive or delete those files based on creation date.... Read more
20 Jul 2015 - less than 1 minute readRegistering with the listener
#oracle #networkWhen restarting a database, if you can’t acess it from outside, you may have to associate the newly restarted database with the listener. The Pmon process that is started with the instance is respo... Read more
20 Jun 2015 - less than 1 minute readMoving MySQL datafiles
#mysql #linuxIn this article, I’ll demonstrate multiple solutions to move datafiles Method 1: using symbolic links Stop the Mysql instance. /etc/init.d/mysql stop Then move the files and put symbolic links ... Read more
20 May 2015 - less than 1 minute readResolve PLAN_TABLE is old version error
#oracleWhen displaying execution plans on SQL*plus, you may notice an information message like so: ------------------------------------------------------------------------------------------------- | Id ... Read more
20 Apr 2015 - 1 minute readCheck database uptime
#database #oracle #mysqlSometimes you have to check when a database was started for the last time. To get the information, just log on to the database and use the following query to get the last startup time: On Oracle d... Read more
20 Mar 2015 - less than 1 minute readChange the default temporary tablespace
#database #oracle #sqlWhen your temporary tablespace gets full and you can’t resize it, you may consider switching ti a new ont to reclaim disk space. Changing the default temporary tablespace will allows you to discard... Read more
20 Feb 2015 - 1 minute readEnable parallel DML
#oracle #sqlEffectively using parallel DML can speed up data manipulation. By the way, DML stands for (Data Manipulation Language), and refers to Insert, Update and Delete which plays at the row level. DDL (D... Read more
20 Jan 2015 - less than 1 minute readGetting the server IP Address from SQL*plus
#system #networkHere’s a small script to get the IP address of the host server directly from the SQL*plus command line. DECLARE v_host_name v$instance.host_name%type; v_ip_address varchar2(50); BEGIN SELECT host_... Read more
20 Nov 2014 - less than 1 minute readORA-01666 When Activating a Physical Standby Database
#oracle #standbyYou’re waking up a Physical standby database, and are welcomed by the following ORA-Code: ORA-01666: controlfile is for a standby database Don’t panick, that’s just because the database has been... Read more
20 Oct 2014 - less than 1 minute read