Statspack summary
This post is a summary of the Oracle Statspack Survival Guide. To install statspack : Create tablespace for it @?/rdbms/admin/spcreate (run as sysdba) To take snaps : exec statspack.snap; To create the report : @?/rdbms/admin/spreport.sql
Read more →Automating FTP
Here’s how you automate FTP : ftp -v -n hostname << EOF user usuario password bin put filename bye EOF With thanks to this post.
Read more →More Google maps stuff
This Google Maps API Tutorial website has some very good how-tos on Google Maps. Needless to say, I added some of those things like Fitting the map to the data and Lots of sidebar entries to my maps. Check out the New Zealand and Firenze maps.
Read more →HP Unix info
This is useful on HP Unix machines. It just prints out a few pieces of data of the machine. echo "HP Unix version : " `uname -a` echo "Model : " `/usr/bin/model` echo "Number of processors : " `/usr/sbin/ioscan -kf | grep processor | wc -l` An example output would be be : HP Unix version : HP-UX machine B.11.23 U ia64 ident_nr unlimited-user license Model : ia64 hp server rx4640 Number of processors : 4 Funnily there doesn’t seem to be a standard command to get the total amount of memory in the machine.
Read more →How much space does an Oracle table take up ?
The following queries can be used to find out how much space a table takes up. The first query gets the block size used in this database. The second one shows how many blocks are used for a table. select value from v$parameter where name = 'db_block_size'; select blocks, last_analyzed from all_tables where owner = 'X' and table_name = 'Y'; The blocks field will have a valid value if the table has been analyzed recently, that is why the last_analyzed field is selected as well.
Read more →