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:
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');
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 ]
echo “Error in $0 – Invalid Argument Count”
echo “Syntax: $0 input_file output_file”
is CSH use:
if( $#argv < 2 ) then
echo “Usage: pltrps filename start_rpnum [ rpnum_inc END_rpnum]”
To view the process consuming the most virtual memory
# prstat -s size -n 5
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.
To “call” a php file within another php file, use this text
find . | xargs grep whatever
I have managed to remove all the folders
I don’t want from Vista Media Centre (VMC).
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
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.
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
To burn the CD:
cdrw -i /full-path/xxx.iso
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:
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
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:
If you issue ANY other commands first then go may not work.
Restore default NVRAM settings
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.