Managing performance using OSWatcher
------------------------------------
Installing OSW is simple and straightforward. Download the tar file from Metalink1 and untar the file at the appropriate location. For example, keeping a mount point for tools will help easy management.
tar xvf osw.nnn.tar
Since this is a shell script, collection can be done either as a foreground process or in the background. To enable data collection in the background, submit the primary script with the "nohup" option.
1. To start the OSW as a foreground process, use startOSW.sh.
2. To stop the OSW foreground process, use stopOSW.sh.
3. To submit the process in the background:
nohup ./startOSW.sh n1 n2 &
where n1 is the interval for each snapshot and n2 is the retention period.
4. To generate graphs for the data collected using OSWg, use
java -jar oswg.jar –I < complete path for the archive directory location>
OSWg requires a Windows type of server.
Note: In a RAC environment, OSWAT CHER needs to be installed and run on all nodes in the cluster.
Configuring OSW to Start Automatically After a System Start:
Step 1: Install the required RPM file to configure oswb as a service
[root@ssky1l4p1 downloads]# rpm -ivh oswbb-service-7.2.0-1.noarch.rpm
Step 2: Set up required parameters for auto start of OSW
[root@ssky1l4p1 ]# vi /etc/oswbb.conf
# Set OSW_ARCHIVE where the logs should be stored
OSW_ARCHIVE='archive'
# Set OSW_COMPRESSION to the desired compression scheme
OSW_COMPRESSION='gzip'
# Set OSW_HOME to the directory where your OSWatcher tools are installed
OSW_HOME='/u01/app/oracle/product /oswbb'
# Set OSW_INTERVAL to the number of seconds between collections
OSW_INTERVAL='30'
# Set OSW_RETENTION to the number of hours logs are to be retained
OSW_RETENTION='48'
# Set OSW_USER to the owner of the OSW_HOME directory
OSW_USER='oracle'
----------------------------
Step 3: Verify the chkconfig to ensure the OSW is enabled for auto start
[root@ssky1l4p1]# /sbin/chkconfig --list oswbb
oswbb 0:off 1:off 2:on 3:on 4:on 5:on 6:off
Step 4: Start OSW as a service
[root@ssky1l4p1]# /sbin/service oswbb start
Step 5: Stop OSW as a service
[root@ssky1l4p1]# /sbin/service oswbb stop
References:
https://blogs.oracle.com/db/entry/master_note_database_performance_overview
Master Note: Database Performance Overview (Doc ID 402983.1)
Master Note: SQL Query Performance Overview (Doc ID 199083.1)
OSWatcher Black Box User's Guide (Doc ID 1531223.1)
OSWatcher Black Box Analyzer User Guide (Doc ID 461053.1)
OSWatcher For Windows (OSWFW) User Guide (Doc ID 433472.1)
Metalink Note #: 301137.1 - O/S Watcher User Guide.
352363.1 LTOM - The On-Board Monitor User Guide.
------------------------------------
Installing OSW is simple and straightforward. Download the tar file from Metalink1 and untar the file at the appropriate location. For example, keeping a mount point for tools will help easy management.
tar xvf osw.nnn.tar
Since this is a shell script, collection can be done either as a foreground process or in the background. To enable data collection in the background, submit the primary script with the "nohup" option.
1. To start the OSW as a foreground process, use startOSW.sh.
2. To stop the OSW foreground process, use stopOSW.sh.
3. To submit the process in the background:
nohup ./startOSW.sh n1 n2 &
where n1 is the interval for each snapshot and n2 is the retention period.
4. To generate graphs for the data collected using OSWg, use
java -jar oswg.jar –I < complete path for the archive directory location>
OSWg requires a Windows type of server.
Note: In a RAC environment, OSWAT CHER needs to be installed and run on all nodes in the cluster.
Configuring OSW to Start Automatically After a System Start:
Step 1: Install the required RPM file to configure oswb as a service
[root@ssky1l4p1 downloads]# rpm -ivh oswbb-service-7.2.0-1.noarch.rpm
Step 2: Set up required parameters for auto start of OSW
[root@ssky1l4p1 ]# vi /etc/oswbb.conf
# Set OSW_ARCHIVE where the logs should be stored
OSW_ARCHIVE='archive'
# Set OSW_COMPRESSION to the desired compression scheme
OSW_COMPRESSION='gzip'
# Set OSW_HOME to the directory where your OSWatcher tools are installed
OSW_HOME='/u01/app/oracle/product /oswbb'
# Set OSW_INTERVAL to the number of seconds between collections
OSW_INTERVAL='30'
# Set OSW_RETENTION to the number of hours logs are to be retained
OSW_RETENTION='48'
# Set OSW_USER to the owner of the OSW_HOME directory
OSW_USER='oracle'
----------------------------
Step 3: Verify the chkconfig to ensure the OSW is enabled for auto start
[root@ssky1l4p1]# /sbin/chkconfig --list oswbb
oswbb 0:off 1:off 2:on 3:on 4:on 5:on 6:off
Step 4: Start OSW as a service
[root@ssky1l4p1]# /sbin/service oswbb start
Step 5: Stop OSW as a service
[root@ssky1l4p1]# /sbin/service oswbb stop
References:
https://blogs.oracle.com/db/entry/master_note_database_performance_overview
Master Note: Database Performance Overview (Doc ID 402983.1)
Master Note: SQL Query Performance Overview (Doc ID 199083.1)
OSWatcher Black Box User's Guide (Doc ID 1531223.1)
OSWatcher Black Box Analyzer User Guide (Doc ID 461053.1)
OSWatcher For Windows (OSWFW) User Guide (Doc ID 433472.1)
Metalink Note #: 301137.1 - O/S Watcher User Guide.
352363.1 LTOM - The On-Board Monitor User Guide.
No comments:
Post a Comment