jump to navigation

Unix Command Notebook 22 September 2010

Posted by Tyo in Uncategorized.
add a comment

A note for command that  usually use on Unix:

1.infinite loop for monitoring space

while true; do df -g /mount1 ; sleep 10; done

2.Find file which modified more than 2 days ago

find /mount1 -name ‘*.123′ -mtime +2

3.Checking oracle connected user (showing pid,memory used, argument)

ps -ef -o pid,vms,args | grep oracle

4.Find file and delete it

find /mount1 -name ‘*.123′ -mtime +3 -exec rm {} \;

ORA-01244 on Physical Standby 14 September 2009

Posted by Tyo in Oracle.
add a comment

Error Message: ORA-01244

and below are steps to resolve the problem.

First thing to do query v$datafile to check the unnamed datafile with this query:

select name from v$datafile; (lagi…)

A Day with Solaris 10 4 Desember 2008

Posted by Tyo in Uncategorized.
1 comment so far

Installing Oracle 10g on many operating system has been my regular jobs for this 2 month. Most of this jobs using Solaris 10 as their operating system. Usually when doing installation, i have a backup from solaris people from many other vendors or their principal to do the setting for solaris 10. I just sit back and relax and watch them do the setting shmmax. It really enjoyable though :D .

(lagi…)

Changing Hostname on Linux 21 Oktober 2008

Posted by Tyo in Linux.
Tags: , ,
1 comment so far

This post is only a reminder for me on “how to change Hostname in Linux”. Since I play a lot with VMWARE, and I already have the Linux OS template, so  i don’t have to do linux installation all the time whenever i need to do new Oracle installation, just change the hostname and ip address and those Linux OS template is ready to use.

(lagi…)

My Oracle Script Collection 15 Februari 2008

Posted by Tyo in Oracle.
add a comment

1. Moving all tables in a schema

select ‘alter table ‘ || table_name || ‘ move tablespace users’ from user_tables;

2. Moving all indexes in a schema

select ‘ALTER INDEX ‘ ||Index_name || ‘ REBUILD TABLESPACE INDX’ from user_indexes;

3. Check Tablespaces size in a database

SELECT df.tablespace_name TABLESPACE, df.total_space TOTAL_SPACE,
fs.free_space FREE_SPACE, df.total_space_mb TOTAL_SPACE_MB,
(lagi…)

Ikuti

Get every new post delivered to your Inbox.