chk_space_SID.ksh
. $ENV_FILE #sqlplus -silent / as sysdba
chk_space_SID.ksh
#Description : This script will check whether free space is there for next extent allocation or not. #It checks TS level and OS level for extent allocation. Checks for UNIFORM allocated extents. #For system allocated extents. this script will check 1 GB should be there as free threshold. NODENAME1=`hostname` ORACLE_SID=WEBP18F LOG_FILE_DIR=/home/oracle/oraprocs/logs ENV_FILE=/home/oracle/oraprocs/WEBP18F.env #NOTIFY_LIST=’8774544468@skytel.com’,’8774537913@skytel.com’,’8666714349@skytel.com’,’8774538204@skytel.com’,’dbaoracle@1800flowers.com’,’8774889576@skytel.com’ NOTIFY_LIST=’pmehta@1800flowers.com’ ADMIN_USER=vivek…
chk_space_SID.ksh
#!/bin/ksh
To Find Orphan OS processes.
To Find Orphan OS processes. When a process run from command line its parent process id will be 1. Consider following example: In current session, we are executing SQLPLUS. whose process id = 22833 and parent is 22822. process 22822 is ksh. So this is not orphan process. if you find any process with parent…
Another Tuning Article for subheap of shared pool
http://www.mail-archive.com/oracle-l@fatcity.com/msg79721.html Oh yeah, I forgot to say that in 9.2.0.3 the shared pool was broken up into “heaps” (Oracle terminology) but whatever fancy stuff they were trying to accomplish by doing this (I think part of the magical self-tuning initiative) was buggy and this hastened the fatal 4031 situation. There is a parameter (so I…
Read More “Another Tuning Article for subheap of shared pool” »
good note for shared pool tunnig
Note:396940.1 How many Subpools will I have by default? The number of subpools is calculated using a simple algorithm. First, a subpool must be at least 128MB in 9i releases and at least 256MB in 10g releases. Bugs and internal tests show that subpools around 500M will work most efficiently and in future versions, we…
When to rebuld B-tree index
Here is the syntax: analyze index CUSTOMER_LASTNAME_IND validate structure; It populates the SYS.INDEX_STATS view only. The SYS.INDEX_STATS view can be accessed with the public synonym INDEX_STATS. The INDEX_STATS view will hold information for one index at a time: it will never contain more than one row. Therefore you need to query this view before you…
Another export with Query
exp userid=cs file=gift_cert_07FEB07.dmp log=gift_cert_07FEB07.log compress=N grants=N tables=gift_certificate statistics=none query=”where dt_crtd >= to_date(’02-04-2007 10:00:00′,’MM-DD-YYYY HH24:MI:SS’)” /* WITH LOG */ imp userid=cs file=gift_cert_07FEB07.dmp log=gift_cert_07FEB07_imp.log ignore=Y grants=N fromuser=cs touser=cs statistics=none constraints=N buffer=10485760 commit=y indexes=N feedback=5000
Composite Index creation tip from Vivek
When you create a composite B-tree index, you should consider the following. The most restrctive condition: The condition that returns the least number of rows. The column that is involved in this condition, should be the leading column of B-tree index. So for finding the candidate of composite index columns, column order should be.. (…
Histogram information
Oracle 10g Histogram ==================== Oracle uses two types of histograms for column statistics (1) height-balanced histograms (2) frequency histograms The type of histogram is stored in the HISTOGRAM column of the *TAB_COL_STATISTICS views (USER and DBA). This column can have values of HEIGHT BALANCED, FREQUENCY, or NONE. (1) Height-Balanced Histograms In a height-balanced histogram, the…