Solaris Performance Check

Source: http://www.adminschoice.com/docs/iostat_vmstat_netstat.htm#Input%20Output%20statistics%20(%20%20iostat%20)

Check Disk Usage:
iostat -mpenxtc 5

WinXP - "No network provider accepted the given network path"

Bloody!!!

I disabled "TCP/IP NetBIOS Helper" service in my Windows XP laptop last week, thinking that nowadays no one will uset NetBIOS. End up I can't access my corporate shared folder and getting error of "No network provider accepted the given network path".
Once I re-enable the service, it works like charm.

How enable it?
1. Open control panel
2. Double click on "Administrative Tools"
3. Double click on "Services"
4. Search the "TCP/IP NetBIOS Helper" and double click it, select Startup Type: "Automatic"
5. If it is stopped, click the start
6. VIOLA! Your are able to reconnect to your shared drive

Ikea Home Planner

Designing your dream home?
Hard to imagine how would it look like?
Wanna save cost from engaging professional service?

Ikea has a very nifty software for you, it called iPlannit.
Best of all, it's free.

Grab it now from http://www.ikea.com.sg/home_planner/home_planner08.asp

[Solaris] How to print folder tree?

root@server$ pwd
/home

root@server$ find . -type d
.
./user01
./user01/data
./user01/log
...

HAPPY!

[Linux] How to Create Swap File?

dd if=/dev/zero of=/swapfile bs=1024 count=100000
This will create file (swapfile) of size 100 MB (round)

mkswap /swapfile


add this file to your swap pool
swapon /swapfile

[Oracle] Mass Script Generation for granting access

select 'grant select on ' || view_name ||' to gen_user;' from user_views


gen_user is your user name

Oracle Cheat

analyze table t_ft_cs_diagnosis compute statistics;
What is it for?

When you create index make sure you include your function column as well...