Gather database statics

There are several ways to gather statics in Oracle. It all depends on how wide you want to do your collection.
To gather statics for the whole database:

SQL> EXEC DBMS_STATS.gather_database_stats;
To gather statics for a single schema:
SQL> EXEC DBMS_STATS.gather_schema_stats('SCOTT');
To gather statics for a single table:SQ
L> EXEC DBMS_STATS.gather_table_stats('SCOTT', 'EMPLOYEES');
To gather statics for a single index:
SQL> EXEC DBMS_STATS.gather_index_stats('SCOTT', 'EMPLOYEES_PK');

For more information see:
http://www.oracle-base.com/articles/8i/CostBasedOptimizerAndDatabaseStatistics.php

Shell script parameter check

To check if your script was given any command like parameters when run use scripts similar to the following,
in BASH use:
if [ $# -ne 2 ]
then
echo “Error in $0 – Invalid Argument Count”
echo “Syntax: $0 input_file output_file”
exit
fi
is CSH use:
if( $#argv < 2 ) then
echo “Usage: pltrps filename start_rpnum [ rpnum_inc END_rpnum]”
exit 1
endif

Removing monitored folders from VMC

I have managed to remove all the folders
I don’t want from Vista Media Centre (VMC).
STEPS:
1: Delete ALL video files from Windows Media Player (WMP) Library.
2: Remove or ignore ALL folders in WMP watched folders except “recorded tv”
3: Remove ALL Folders from VMC except “recorded tv”
4: Delete ALL video files, folders and shortcuts from the folder \USERS\PUBLIC\PUBLIC VIDEOS
5: Delete Shortcut to Sample videos from \USERS\PUBLIC\RECORDED TV
6: Delete ALL video files, folders and shortcuts from the folder \USERS\\VIDEOS
7: REBOOT!!!!!!!!!!!!
8: Add a folder/shortcut heirarchy to the folder \USERS\PUBLIC\PUBLIC VIDEOS containing links to only
the folders you want monitored or tv the Videos folder of the normally logged on user.
DO NOT ADD ANY FOLDERS TO WATCHED LIST IN WMP OR VMC
NOTE : The above steps worked for me but cause VMC to behave a bit strangely.
What also worked was doing the above,
then adding the folder you want watched to WMP.

How to create ISO image in Solaris

Data To CD
To create ISO image:

mkisofs -o xxx.iso -J -R /full-path-to-data/

CD to CD
Capture an ISO image file of the CD by typing (at root prompt):

# dd if=/dev/dsk/c0t6d0s2 of=/root/64bit_disk3.iso

You may have to disable volume management first, by running:

# svcadm disable volfs

You may also have to run both commands as root
Burn ISO
To burn the CD:

cdrw -i /full-path/xxx.iso

Sun OpenBoot Prom Commands

Sun computers use a boot monitor program called “OpenBoot”. From the boot monitor we can perform certain hardware tests, issue boot instructions, and set many parameters stored in nonvolatile RAM on the CPU board. Some of these setting must be adjusted for particular situations.
Full documentation is available at:
http://docs.sun.com:80/ab2/coll.216.2/@Ab2CollView
Getting to the boot monitor
The best way is to cause an orderly system shutdown with
one of these commands, shown in order of preference:
shutdown -yi 0
init 0
halt
If this is not possible then it can be forced by:
From the tty console send a RS-232 BREAK signal.
(serial consoles default to 9600,8,N,1)
From a Sun Framebuffer/keyboard press the STOP key
and the ‘a’ key at the same time.
In general this method is BAD and has the same risks to
the file system as just turning off the power.
If you accidently sends a break or STOP-a, you can safely
return to the running OS state with this command:

ok> go

If you issue ANY other commands first then go may not work.
Restore default NVRAM settings

ok> set-defaults

Set boot device

ok> setenv boot-device disk

Other options include:
disk0 main SCSI controller target 0
disk1 main SCSI controller target 1
disk2 main SCSI controller target 2
disk3 main SCSI controller target 3
disk is same as disk3
[if disk is not main SCSI controller ]

ok> nvalias disk /sbus@1,f8000000/dma@3,81000/esp@3,80000/sd@3,0

System may take 30 seconds during POST to show any response.