Database Systems

Database Systems is a blog about Databases and Data of any size and shape

Pages

▼
Friday, 22 July 2005

How to create / read unix tar files

›
To create a unix tar file supply the path to the directory which you want to tar in the 'directoryname' below: $ tar cvf filename.ta...
Thursday, 5 May 2005

Import time monitoring

›
Use this script to monitor how long the import into a table takes and how many rows have already been imported. Log in as sysdba to do that....
Tuesday, 12 April 2005

Delete files older than X certain days

›
To delete files older than certain days you use -mtime argument of the find command like this. The following example deletes files which s...
Friday, 25 February 2005

See what's in the DB_CACHE_BUFFER

›
See what's in you db_cache buffer at that time, log on as SYSDBA and run the following query. You will see what occupies the db_cache bu...
Wednesday, 16 February 2005

Solaris ls command to list large files

›
Use this command on Solaris with bash, to get your files sorted from the smallest to the largest and quickly list large files. $ ls -lhs | s...
‹
›
Home
View web version
Powered by Blogger.