vi Quick Reference
This table is taken from Sun Microsystems' User's Guide: Getting Started (. Starting vi vi filename open or create file vi +18 filename open to line 18 vi +/"mustard" filename open file to first occur[...]
Author Archive
Tuning Oracle’s Buffer Cache
Oracle maintains its own buffer cache inside the system global area (SGA) for each instance. A properly sized buffer cache can usually yield a cache hit ratio over 90%, meaning that nine requests out of ten are satisfied[...]
RedHat5 rpmdb-redhat
Place all the rpm packages in one local sub-directory (lets say RHEL5) which does not have and sub-directorires and do; rpm -ivh createrepo*.rpm createrepo /RHEL5 Then in the /etc/yum.repos.d directory place a file named[...]
Adding a new disk to a VMWare Virtual Machine in Linux
I’ve been using VMWare for a while now and I always get asked some common questions about it. One of those is how to add a new virtual disk to a Linux virtual machine. So in response to that, here are the steps to addi[...]
Linux Commands – A practical reference
This is a linux command line reference for common operations. Examples marked with • are valid/safe to paste without modification into a terminal, so you may want to keep a terminal window open while reading this so yo[...]
Export TABLE Records into Flat File with INSERTs
The GENERATE_STMT procedure of this UTILITY package needs four parameters i.e. TABLE NAME, WHERE CLAUSE, PATH WHERE Developer WANT FILE TO BE GENERATED and FILE NAME. WHERE CLAUSE value must be passed in the form of q[...]
Trigger to Prevent Dropping Objects
This trigger secures objects, preventing a user from dropping them by mistake. To begin, create a table for the example below called secured_objects with a column objectname, with datatype varchar2(20). Insert a record i[...]
Find Invalid Synonyms
“ORA-00980: synonym translation is no longer valid” is a common error encountered in a development environment. This can happen for many reasons. Some of them are 1. You created a synonym on non-existing obje[...]
Find Full Table Scans
This query provides a list of queries (1,000 characters only) involved in full table scans. The total number of rows and blocks for each table is also displayed so that you can determine whether the full scan is degradin[...]
Instance Background Processes Information
This script displays instance background process information. The script works when the database is MOUNTed or OPENed. -- Oracle 8I select A.SID, A.SERIAL#, A.PROGRAM, P.PID, [...][...]
