Month: January 2008

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 […]

Compiling schema objects

The COMPILE_SCHEMA procedure in the DBMS_UTILITY package compiles all procedures, functions, packages, and triggers in the specified schema. The example below shows how it is called from SQL*Plus for the SCOTT schema. SQL> EXEC DBMS_UTILITY.compile_schema(schema => ‘SCOTT’);

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: […]

Connecting to MySQL

At your shell prompt type # mysql -u <username> –password=<password> Where <username> and <password> are the username and password you entered when first setting up MySQL. You may also be able to login as root like this, # mysql -u root without using a password, depending on how your system was setup.

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, […]

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 […]

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 […]

Next Page »