Keep walking

Whatever you need to grow, just do it faster…

Archive for the ‘.Sojungle News’ Category

A List of FTP Commands

Posted by ZyK on 05/23/2012

Introduction

The following information is provided as a reference for the File Transfer Protocol (FTP) commands. This document describes a typical process for an interactive and automated, batch FTP session running on a PC with Windows/XP and connecting to a UNIX system. This process may vary slightly depending on the hardware and software configurations of the local and remote systems.

An Interactive FTP Session
(Next) (Previous) (Table-of-Contents)

To start an FTP interactive session type “ftp” from a DOS Command window.

C:\> ftp

The DOS prompt should be replaced with the FTP prompt. The FTP program is now running on the local system. A connection (or session) to a remote system has not been established.

The help command or ? (question mark) may be executed without being attached to a remote system and will do a print (usually to the screen) of the FTP commands. The following is an example of an FTP Command to display the FTP Help information.

ftp help

The following is a typical result of the help command running on a PC with Windows.

Commands may be abbreviated. Commands are: ! delete literal prompt send ? debug ls put status append dir mdelete pwd trace ascii disconnect mdir quit type bell get mget quote user binary glob mkdir recv verbose bye hash mls remotehelp cd help mput rename close lcd open rmdir ftp

The following FTP Command will perform the FTP OPEN (make the connection) and display the following messages.

ftp  open domain.name 
Connected to domain.name
220 antigonous FTP server ready.
User (domain.name:(none)): User-Name
331 Password required for user-name
Password: password
230 User user-name logged in.
ftp

The following FTP Command will change the directory on the remote system and display the following message.

ftp> cd /web
250 CWD command successful.
ftp

The following FTP Command will find out the pathname of the current directory on the remote system and display the information.

ftp> pwd
257 "/web" is the current directory.
ftp

The following FTP Command will set the file transfer mode to ASCII (this is the default for most FTP programs) and display the information.

ftp> ascii
200 Type set to A.
ftp

The following FTP Command will copy a file(using ASCII mode) from the local system to the remote system and display the information.

ftp> put d:\simoweb1\filename.txt
200 PORT command successful.
Opening ASCII mode data connection for filename.txt
226 Transfer complete
ftp

The following FTP Command will set the file transfer mode to BINARY (the binary mode transfers all eight bits per byte and must be used to transfer non-ASCII files). ) and display the information.

ftp> binary
200 Type set to I.
ftp

The following FTP Command will copy a file (using BINARY mode) from the local system to the remote system and display the information.

ftp> put d:\simoweb1\filename.zip
200 PORT command successful.
Opening BINARY mode data connection for filename.zip
226 Transfer complete
ftp

The following FTP Command will exit the FTP environment (same as “bye”) and display the information.

ftp> quit
221 Goodbye.

When the preceding FTP Command is finished the DOS prompt will be displayed.

C:\>

The preceding is a typical process for an interactive FTP session running on a PC with Windows/XP or Windows/7 and connecting to a UNIX system. This process may vary slightly depending on the hardware and software configurations of the local and remote systems.

An Automated, Batch FTP Session
(Next) (Previous) (Table-of-Contents)

The following batch file (UPWIP001.BAT) will start an FTP session and pass the name of a text file (UPWIP001.TXT) to the FTP program. This text file will be processed by the FTP program and each of the statements in the text file will be processed in the sequence they appear.

@echo OFF
rem  * *******************************************************************
rem  *               FTPSAME1.CMD - a Windows Command File               *
rem  *         This program is provided by SimoTime Enterprises          *
rem  *           (C) Copyright 1987-2011 All Rights Reserved             *
rem  *             Web Site URL:   http://www.simotime.com               *
rem  *                   e-mail:   helpdesk@simotime.com                 *
rem  * *******************************************************************
echo *
echo * This batch and text file illustrate the use of FTP to upload an
echo * ASCII file and an EBCDIC or Binary file. The UPWIP001.BAT file
echo * references UPWIP001.TXT that contains...
echo *
echo *   user
echo *   password
echo *   cd /web
echo *   pwd
echo *   ascii
echo *   put d:\simoweb1\cbltxn01.htm
echo *   binary
echo *   put d:\simoweb1\cbltxn01.zip
echo *   quit
echo *
ftp -s:upwip001.txt www.simotime.com

The following is a listing of the contents of the text file (UPWIP001.TXT).

user password
cd /web
pwd
ascii
put d:\simoweb1\cbltxn01.htm
binary
put d:\simoweb1\cbltxn01.zip
quit

An FTP Command List

The following is a summary of the commonly used FTP Commands.

Command Description
! Preceding a command with the exclamation point will cause the command to execute on the local system instead of the remote system.
? Request assistance or information about the FTP commands. This command does not require a connection to a remote system.
ascii Set the file transfer mode to ASCII (Note: this is the default mode for most FTP programs).
bell Turns bell mode on / off. This command does not require a connection to a remote system.
binary Set the file transfer mode to binary (Note: the binary mode transfers all eight bits per byte and must be used to transfer non-ASCII files).
bye Exit the FTP environment (same as quit). This command does not require a connection to a remote system.
cd Change directory on the remote system.
close Terminate a session with another system.
debug Sets debugging on/off. This command does not require a connection to a remote system.
delete Delete (remove) a file in the current remote directory (same as rm in UNIX).
dir Lists the contents of the remote directory.The asterisk (*) and the question mark (?) may be used as wild cards. For example:
get WIP
help Request a list of all available FTP commands. This command does not require a connection to a remote system.
lcd Change directory on your local system (same as CD in UNIX).
ls List the names of the files in the current remote directory.
mget WIP
mkdir Make a new directory within the current remote directory.
mput Copy multiple files from the local system to the remote system. (Note: You will be prompted for a “y/n” response before copying each file).
open Open a connection with another system.
put Copy a file from the local system to the remote system.
pwd Find out the pathname of the current directory on the remote system.
quit Exit the FTP environment (same as “bye”). This command does not require a connection to a remote system.
rmdir Remove (delete) a directory in the current remote directory.
trace Toggles packet tracing. This command does not require a connection to a remote system.
  A List of FTP Commands

FTP Command, DIR
(Next) (Previous) (Table-of-Contents)

The DIR command will list the contents of the remote directory.The asterisk (*) and the question mark (?) may be used as wild cards.

Parameters Description
b* This will display all entries that start with the letter “b”. For example, the following will be displayed.
bet, ben, bingo, born, boon, bipartisan, bandit, boy
b*n* This will display all entries that start with the letter “b” and have the letter “n” somewhere after the letter “b”. For example, the following will be displayed.
ben, bingo, born, boon, bipartisan, bandit
The following will not be displayed.
bet, boy
b?n This will display all entries that start with the letter “b”, have the letter “n” in the 3rd position and have a three character name. For example, the following will be displayed.
ben
The following will not be displayed.
bet, bingo, born, boon, bipartisan, bandit, boy
b?n* This will display all entries that start with the letter “b” and have the letter “n” in the 3rd position. For example, the following will be displayed.
ben, bingo, bandit
The following will not be displayed.
bet, born, boon, bipartisan, boy
  A List of Parameters for the DIR FTP Command

An FTP Extended Command List

The following are additional commands that are used when tranferring files between an IBM Mainframe and a Windows or UNIX client system. Also, the following includes commands required when working with files containing variable length records.

Command Description
literal Will send an argument to the remote FTP Server. This statement is similar in purpose as the “QUOTE” statement.
locsite LOCSITE This statement may be used at the mainframe for commands specific to the mainframe
quote Will send an argument to the remote FTP Server. This statement is similar in purpose as the “LITERAL” statement.
site This parameter is used at the client system to transfer a function (via the LITERAL or QUOTE statement) to the host site. The following is a summary of the commonly used SITE/LOCSITE Commands.
  A List of Extended FTP Commands

FTP Extended Command, LOCSITE, LITERAL and SITE

This SITE (via the literal or quote command) statement is used at the client system and the LOCSITE command is used at the host system. Both statements are used to transfer a function to the host site. The following is a summary of the commonly used SITE/LOCSITE Commands.

Command Description
BLKSIZE BLocKSIZE=nnnn where nnnn is the block size (BLKSIZE)
CYLINDERS CYlinders To indicate that space should be allocated in cylinders
DIRECTORY DIrectory=nnn where ‘nnn’ indicates the number of directory blocks to be allocated for the directory of a PDS
LRECL LRecl=nnn where nnn is the logical record length (LRECL)
PRIMARY PRImary=nnn where nnn indicates the number of primary space units (tracks or cylinders)
RDW RDW will cause each record of a variable length record to be preceded with a four byte Record Descriptor Word (RDW) and possible four byte Block Descriptor Word (BDW).
RECFM RECfm=format where format is: F, FA, FB, FBA, FBM, FM, U, V, VA, VB, VBA, VBM, or VBS
SECONDARY SECondary=nnn where nnn indicates the number of secondary space units (tracks or cylinders)
TRACKS TRacks To indicate that space should be allocated in tracks.
  Parameters used with the LOCSITE Extended FTP Commands

The following is an example of the LITERAL command and a GET command. The commands are executed at the client and will cause the RDW (Record Descriptor Word) to be included at the beginning of each record of a file with variable length records.

LITERAL SITE RDW
GET host-file-name client-file-name

The following is an example of the LOCSITE command and a PUT command. The commands are executed at the host and will cause the RDW (Record Descriptor Word) to be included at the beginning of each record of a file with variable length records.

LOCSITE RDW
PUT host-file-name client-file-name

Summary

The purpose of this document is to provide a quick reference for connecting and exchanging information between two systems. This document describes a typical process for an interactive or automated, batch File Transfer Protocol (FTP) session running on a PC with Windows/2000 and connecting to a UNIX system. This process may vary slightly depending on the hardware and software configurations of the local and remote systems.

This document may be used to assist as a tutorial for new programmers or as a quick reference for experienced programmers. In the world of programming there are many ways to solve a problem. This documents and the links to other documents are intended to provide a choice of alternatives.

Software Agreement and Disclaimer

Permission to use, copy, modify and distribute this software, documentation or training material for any purpose requires a fee to be paid to SimoTime Enterprises. Once the fee is received by SimoTime the latest version of the software, documentation or training material will be delivered and a license will be granted for use within an enterprise, provided the SimoTime copyright notice appear on all copies of the software. The SimoTime name or Logo may not be used in any advertising or publicity pertaining to the use of the software without the written permission of SimoTime Enterprises.

SimoTime Enterprises makes no warranty or representations about the suitability of the software, documentation or learning material for any purpose. It is provided “AS IS” without any expressed or implied warranty, including the implied warranties of merchantability, fitness for a particular purpose and non-infringement. SimoTime Enterprises shall not be liable for any direct, indirect, special or consequential damages resulting from the loss of use, data or projects, whether in an action of contract or tort, arising out of or in connection with the use or performance of this software, documentation or training material.

Downloads and Links to Similar Pages

This section includes links to documents with additional information that is beyond the scope and purpose of this document.

A good place to start is The SimoTime Home Page via Internet Connect for access to white papers, program examples and product information.

Note: You must be attached to the Internet to download a Z-Pack or view the list.

Explore The File Status Return Codes to interpret the results of accessing VSAM data sets and QSAM files.

This link provides  Sample FTP Scripts and Windows Command Files  that will transfer files between a Mainframe Host System and a Windows Client System

Glossary of Terms
(Next) (Previous) (Table-of-Contents)

Check out  The SimoTime Glossary  for a list of terms and definitions used in the documents provided by SimoTime.

Comments, Suggestions or Feedback
(Next) (Previous) (Table-of-Contents)

This document was created and is copyrighted and maintained by SimoTime Enterprises.

If you have any questions, suggestions, comments or feedback please call or send an e-mail to: helpdesk@simotime.com

We appreciate hearing from you.

Company Overview

Founded in 1987, SimoTime Enterprises is a privately owned company. We specialize in the creation and deployment of business applications using new or existing technologies and services. We have a team of individuals that understand the broad range of technologies being used in today’s environments. This includes the smallest thin client using the Internet and the very large mainframe systems. There is more to making the Internet work for your company’s business than just having a nice looking WEB site. It is about combining the latest technologies and existing technologies with practical business experience. It’s about the business of doing business and looking good in the process. Quite often, to reach larger markets or provide a higher level of service to existing customers it requires the newer Internet technologies to work in a complementary manner with existing corporate mainframe systems.

Whether you want to use the Internet to expand into new market segments or as a delivery vehicle for existing business functions simply give us a call or check the web site at http://www.simotime.com


Return-to-Top
File Transfer Protocol (FTP), a List of FTP Commands
Copyright © 1987-2012 SimoTime Enterprises  All Rights Reserved
When technology complements business

Posted in Tools | Tagged: , | Leave a Comment »

Oracle Tuning

Posted by ZyK on 12/02/2011


 

ISBN
0-9797951-9-2
ISBN 13:
978-0-9797951-9-0
Library of Congress Number: 2010900994
1,150 pages: Hardcover -  8×10 PD 511
Shelving: Database/Oracle Oracle in-Focus Series:  # 32
Oracle Tuning
The Definitive Reference
Second Edition


Donald K. Burleson
Retail Price $69.95 USD/  £45.95 / $75.95 Canadian

Order now for 40% off ! Only $41.95
(40% off)

Table of Contents:

Using the Online Code Depot
Oracle Script Collection
Conventions Used in this Book
Are you ready to tune?
Acknowledgements
Preface

Chapter 1:  Introduction to Oracle Tuning      

An Introduction to Oracle Tuning
Throughput vs. Response Time
Top-down Tuning vs. Bottom-up Tuning
Proactive Tuning vs. Reactive Tuning

Reactive Oracle Tuning
Proactive Oracle Tuning

Know the Limits:  Things that We Can Not Tune
Oracle Application-level Tuning
A Historical Review of DBA Job Duties
Oracle Tuning and Server Consolidation
Hardware Technology Drives Database Technology
The Changing Role of an Oracle Tuning Professional

The Causes of Poor Oracle Performance
The Oracle Tuning Hierarchy
External Hardware Performance Review
Finding Database Bottlenecks
Oracle Instance Tuning
AWR Licensing Options
Tracking your Oracle Option Usage
Oracle SQL Tuning

Conclusion
Chapter 2:  Time-Series Oracle Tuning         

Managing the Complexity of Oracle
The Pros and Cons of Time Series Tuning
Data Quality
Oracle’s Approach to Workload Thresholds
Signatures, Workloads and Exceptions
Workloads and Predictive Analysis
What is an Oracle Workload?

Using Adaptive Thresholds for Predictive Modeling
Using OEM for Predictive Modeling
Time Series Tuning Guidelines
Scheduling an SGA Reconfiguration
Trend-based Oracle Reconfiguration
When to Trigger a Dynamic Reconfiguration

Approaches to Self-tuning Oracle Databases
Tuning a Constantly Changing Database
Can Oracle Possess Psychic Abilities?

Capturing Time Series Metrics

Customized AWR Tuning Reports
Exception Reporting

Exception Reporting with the AWR
Exception Reporting with dba_hist_filestatxs

Trend Identification with the AWR
Conclusion
References   

Chapter 3:  The Time Model Tuning Approach        

Inside the Oracle Time Model Views
Displaying Session Details with Time Model Data
Real-time Reporting
Time Model Tables in AWR
Time Model Statistics
Conclusion
Chapter 4:  Predictive Modeling 

Predicting the Future with Oracle
Oracle Data Mining and Predictive Analytics
The Evolution toward Data Mining
Oracle Data Mining and Predictive Analytics
Components of the Oracle Data Miner

Predictive Models Made Easy
Exception Reporting with the AWR
General Trend Identification with the AWR

Correlation Analysis with AWR and ASH
Predictive Modeling with dba_hist_filestatxs

Conclusion

Chapter 5:  Oracle Troubleshooting  

Introduction to Troubleshooting
Emergency Troubleshooting Methods
Why Oracle Shops Lose Their Databases
The Limitations of the DBA

Case Studies in Oracle Troubleshooting
Accurately Measuring Oracle Performance

Using the BCHR for Performance Tuning
The Danger of Relying on Blanket Ratios

Oracle Bottleneck Analysis
Prerequisites for Bottleneck Analysis
Combining Bottleneck and Ratio Analysis
The Number One Oracle Performance Myth

Troubleshooting Oracle Disk Performance
Automatic Growth

Troubleshooting Critical Storage Problems
Detecting Tablespace Fragmentation
Detecting Object Fragmentation
Correcting Object Fragmentation

Troubleshooting Table Problems
Index Diagnostics
Correcting Space-related Object Performance Problems

Troubleshooting Memory Problems
Getting a Handle on Memory Usage

Understanding the SGA
Gaining Insight Into Memory Use
The Buffer Cache Hit Ratio – Still Worthwhile?

Troubleshooting the Shared Pool
When Does Less Become More?

Troubleshooting the Log Buffer
Log Buffer Related Parameter Issues
Investigating Sorts

Troubleshooting Oracle Sorting
buffer busy waits

Troubleshooting Latches
Troubleshooting I/O Hotspots
Global Basic Queries
Locating Hot I/O Objects
Examining Background Processes
Troubleshooting Rollback Activity

Troubleshooting Problem Sessions
Finding Storage Hogs
Locating Top Resource Sessions
Pinpointing Sessions with Problem SQL

Troubleshooting Problem SQL
What is Bad SQL?

Proactive SQL Troubleshooting
Tricks for SQL Troubleshooting

Troubleshooting Triage
Using Active Session History (ASH) for Troubleshooting
Collecting ASH Wait Information
Using ASH for Troubleshooting
Inside v$active_session_history
Display SQL Wait Details in ASH
Event Wait Analysis with ASH
The Performance Overhead of Collecting ASH Data
Inside the v$session_wait_history
Signature Analysis of ASH Wait Events
Using ASH in OEM

Conclusion 

 
Chapter 6:  Inside STATSPACK and AWR         

Introduction to Tuning with STATSPACK
Oracle vs. STATSPACK

Inside the AWR tables
Using STATSPACK for Oracle Tuning
The structure of the STATSPACK tables
How STATSPACK Works
Trend Reports with STATSPACK

Inside the AWR Tables
The AWR Data Collection Mechanism
Customizing AWR snapshots
The Mysterious AWR Performance Tables

Inside the AWR Tables
Inside the dba_hist Tables
Database Wait Events in AWR
The AWR Metric Tables

AWR System Statistics
Operating System Statistics in AWR
SQL Statistics in AWR
Segment Statistics in AWR
Datafile I/O Statistics in AWR

Conclusion

Chapter 7:  AWR and STATSPACK Configuration    

The Differences between STATSPACK and AWR
Installing STATSPACK
Install Prerequisites

STATSPACK vs. AWR
Statistic Management in AWR and STATSPACK
The snap_level Parameter
The session_id
The num_sql
What SQL is Captured?

STATSPACK SQL Collection Thresholds
AWR SQL Collection Thresholds
The stats$sql_summary Table

Installing AWR
The dbms_workload_repository Package

Creating an AWR Report
Report Naming

Conclusion

Chapter 8:  Reading an AWR or STATSPACK Report        

The Evolution of the Elapsed Time Report
What’s  New in STATSPACK and AWR Reports
Generating a STATSPACK Report
Generating an AWR Report

Reading the STATSPACK / AWR Report
STATSPACK / AWR Report Summary
Cache Sizes Section

Load Profile
Instance Efficiency Percentage
All about Oracle Ratios
Top 5 Timed Events Section of a STATSPACK / AWR Report
The Wait Events Section of the AWR / STATSPACK Report
Wait Event Histogram Section
Instance Activity Section in the STATSPACK / AWR Report
Instance Recovery Statistics Section of a STATS/AWR Report
PGA Section
Process Memory Summary Section
Enqueue Statistics
Rollback Segments
Undo Segments
Latch Activity Section of a STATSPACK / AWR report

Dictionary and Library Cache Stats
The Shared Pool Advisory Section
The Time Model Statistics section
The Operating System Statistics Section
The Top SQL Section
The Instance Activity Section
The I/O Reports Section

The Advisory Sections
Buffer Pool Advisory
The Buffer Wait Statistics Section

Conclusion

Chapter 9:  Oracle Metrics and v$ Tuning Views           

Classifying v$ Views and Metrics
Inside the Oracle Metrics
Inside the v$metric Tables
Database Wait Metrics
Oracle File Metrics
Oracle Service Metrics

The Secret World of the v$ Views
The Active Session History v$ View
Conclusion

Chapter 10:  Oracle Wait Event Tuning       

The Oracle Wait Event Model
The AWR Wait Event Tables
Why Wait Event Tuning for Oracle?
Addressing Wait Bottlenecks
Systemwide Wait Event Tuning
Not All Events Are Created Equal

Inside the Real-time V$ Wait Events
Inside v$session_wait
Inside v$session_event

Conclusion

Chapter 11:  Oracle Tuning Tools   

The Evolution of Oracle Tuning Tools
The Spirit of Independence
A Best Practices Approach to Oracle Tuning
The History of Oracle Tuning Techniques
An Automated Approach to SQL Tuning
How Fully Automated SQL Tuning Works
Fully Automated SQL Tuning is not a Panacea

Oracle Trace Analyzer (sqltxplain)
Oracle Lightweight Onboard Monitor (LTOM)
LTOM Features

Oracle Trace Utility
Inside Oracle Event Tracing
Setting an Oracle Trace Event
Accessing Oracle Trace Records with External Tables
Exception Reporting within a Trace File
Loading and Analyzing the 10046 Event
Inside the Oracle 10046 Trace File Output
Conclusions on Tracing

Generating Oracle Test Data
Gathering a Sample Workload in Oracle 11g
Creating Data for Performance Testing

Conclusion

Chapter 12:  Server & Network Tuning    

Oracle Server Tuning
Outside the Oracle Instance
Oracle Server Bottlenecks

Oracle Server Monitoring
Capturing Server-side Metrics
OS Statistics for the Cost-based Optimizer
OS data inside Oracle views

The Oracle OS Watcher utility
Starting Oracle OS Watcher

Oracle CPU Tuning
Viewing CPU Utilization for Oracle
Identifying High CPU Usage with vmstat
Storing Information from vmstat

Disk I/O and Oracle
Moore’s Law and Disk Speed
Server RAM and Oracle
Oracle and the 64-bit Server Technology
The New Age of Oracle Server Consolidation
Oracle Enterprise Manager and Server Metrics
Server Metrics and SQL Execution

Oracle Network Tuning
Conclusion

Chapter 13:  Tuning the I/O Subsystem

Inside Oracle Disk Architecture
The Plague of Large Oracle Disks
Disk Architectures of the 21st Century

RAID Technology and Oracle
RAID 5 is Not for Every Database

Oracle and Direct I/O
Enabling Oracle Direct I/O

Calibrating Disk I/O
Monitoring External Disk I/O
Capturing External iostat Information
Generating iostat Reports
Solutions to Physical Read Waits

Choosing a default blocksize
Using Oracle Multiple Blocksizes
Reducing Data Buffer Waste with multiple blocksizes
Reducing Logical I/O with Multiple Blocksizes
Improving Buffer Efficiency with Multiple Blocksizes
Improving SQL Execution with Multiple Blocksizes
Real World Applications of Multiple Blocksizes

The db_file_multiblock_read_count Parameter
Oracle Blocksize & Index I/O
The Latest Consensus on Using Multiple Blocksizes
Vendor Notes on Oracle Multiple Blocksizes

Reducing Disk I/O with SSD
2010 Market Survey of SSD Vendors for Oracle

Oracle Disk Monitoring
Examining Real-time Disk Statistics
Examining Global I/O
Tracking I/O for Specific Tables

Analyzing Real Time I/O Waits
Collecting Real-Time Disk Wait Events

Find the Current Disk I/O Session Bandits
Measuring Disk I/O Speed
Time Series I/O Wait Analysis
Time Series Monitoring of the Data Buffers
Monitoring Disk I/O with AWR
Conclusion

 
 
 
Chapter 14:  Oracle Instance Tuning  

Inside Instance Tuning
Instance Tuning Comes First
Instance Configuration for High Performance
Automatic Memory Management
Manual RAM allocation vs. AMM

Sizing the Oracle SGA and PGA Regions
Viewing Server RAM Resources
Sizing your SGA
SGA Sizing on a Dedicated Server
RAM and Virtual Memory for Oracle
Finding the High Water Mark of Oracle User Connections
.
Determining the Optimal PGA Size
Display PGA Area Sizes
A Script for Estimating Total PGA RAM
Optimizing pga_aggregate_target

Rules for adjusting

Important caveats in PGA management
Sizing your PGA for hash joins
The 11g full hash join
Sizing the PGA for Batch Processing
A case study RAM hash joins
Hidden Parameters for Oracle PGA Regions
Supersizing the PGA
Monitoring Server Resources in MS Windows

OS Kernel Parameters
Server Settings for Windows Servers
Kernel Setting for UNIX and Linux Servers

Oracle Parameter Tuning
Oracle Hidden Parameters
Oracle Parallel Query Parameters
Hidden Parallel Parameters
SQL Optimizer Parameters
Data Buffer Cache Hidden Parameters

Instance Wait Event Tuning
Tuning the Oracle Data Buffer Pools
The Problem of Duplicitous RAM Caches
Why is Oracle Logical I/O So Slow?

Data Block Caching in the SGA
Full Table Caching in Oracle
Oracle Data Buffer Metrics
Using AWR for Buffer Pool Statistics
Oracle’s Seven Data Buffer Hit Ratios
Viewing Information about SGA Performance
AMM and Oracle Instance Tuning

Internals of the Oracle Data Buffers
Finding Hot Blocks inside the Oracle Data Buffers
Viewing the Data Buffer Contents

The Downside of Mega Data Buffers
Allocating Oracle Objects into Multiple RAM data Buffers
Sizing the KEEP Pool

Automating KEEP Pool Assignment
Tuning the RECYCLE Pool
Large Blocks and Oracle Instance Caching
Finding Baselines
Learning Instance Tuning from Performance Benchmarks
Rules for adjusting shared_pool_size
Sizing the Shared Pool with the Oracle Advisory Utility
Rules for Adjusting the Data Buffer Sizes

Monitoring RAM usage
Tracking hash joins
Viewing RAM usage for hash joins in SQL

Conclusion

Chapter 15:  Tablespace & Object Tuning       

Oracle Tablespace Tuning
Inside Oracle Tablespace Tuning
The Issue of pctfree
The Freelist Unlink Process
The Issue of pctused

Setting Pctfree and Pctused
Freelists and Performance

ASSM and Tablespace Performance
Internal Freelist Management
Characteristics of Bitmap Segment Management
New High Watermark Pointers
Extent Control Header Block

Using ASSM with RAC
Potential Performance Issues with ASSM
Faster SQL with Database Reorganizations
Managing Row Chaining in Oracle
A Summary of Object Tuning Rules

Reorganizing Tables for High Performance
Online Reorganization
Segment Space Growth Prediction

Tuning SQL Access with clustering_factor
Not all Indexes are Used in Range Scans

Rebuilding Indexes
When to Rebuild Indexes

Oracle Parallel DDL
Invoking Parallelism
Parallel DBA Operations

Conclusion

Chapter 16:  Inside Oracle SQL Tuning      

Introduction to Oracle SQL
The Origin of SQL
Understanding SQL Tuning
Holistic Oracle SQL Tuning
Dealing with Time Constraints

Best Practices for SQL Optimization
Proper Development Environment
Maintaining A SQL Infrastructure
A Release-centric Approach to Holistic Optimization
Oracle 6 – Oracle 7 enhancements
Oracle 8 – Oracle 8i enhancements
Oracle 9i enhancements
Oracle 10g enhancements
Oracle 10g Release 2 enhancements
Oracle 11g enhancements

What is the Best Optimizer Philosophy?
The Persistent SQL Philosophy
The Dynamic SQL Philosophy

Goals of SQL Tuning
Determine Optimal Table Join Order
Remove Unnecessary Large-table Full-table Scans

Locating full-scan operations
Tuning large-table full-table scans
Tuning small-table full-table scans
Optimizing SQL RAM Resources
Cache Small-table Full-table Scans
Verify Optimal Index Usage
Verify Optimal Join Techniques
Tuning by Simplifying SQL Syntax

Roadblocks to SQL Tuning
SQL Profiles

Tracing SQL Execution History
Oracle SQL as a Database Access Method
The rule Hint is still Popular in Oracle 11g
The Library Cache and Oracle SQL Performance
Using cursor_sharing=force

Oracle Cursor Sharing Enhancements
Oracle ISO 99 Table Syntax
Outer Join
Syntax
External Tables and SQL
Defining an External Table
Internals of External Tables

Tuning Distributed SQL Queries
Subqueries and SQL
Basic SQL Subqueries
Scalar Subqueries
In-line Views (Subqueries in the from Clause)

Inside Oracle Views
Benefits of Oracle Views
The Downside to Using Views
Combining Hints and Views
Parsing SQL Syntax
Create Executable
Interrogating SQL Execution Plans

Oracle SQL Optimizer Statistics
The Oracle dbms_stats Package
Managing Schema Statistics with dbms_stats
Column Skew and histograms
Automating Histogram Sampling with dbms_stats
Oracle Workload Statistics and SQL Performance
External Costing with the Optimizer
Tuning SQL with Histograms
Determining the Optimal Table Join Order
How is Join Cardinality Estimated?

Oracle Join Elimination
Using Dynamic Sampling
Sampling Table Scans

Oracle Tuning with Hints
When hints appear to be ignored
Oracle Indexes – Is Maintenance Required?

Identifying Problem SQL
Find the Problem Sessions

AWR and SQL Tuning
Viewing Table and Index Access with AWR
Towards Automated SQL Tuning
The Goals of Holistic SQL Tuning
The SQL Tuning Advisor
Using SQL Tuning Advisor Session
Inside the 11g SQL Performance Analyzer
Inside the Oracle 11g SQL Performance Analyzer
Gathering the SQL Tuning Set
Setting the SQL Optimizer Cost Model
Turning on CPU Costing

Tuning SQL with “rownum” Filters
Using rownum for top-n queries
Using rownum with range bound queries
Alternatives to rownum
Using OPQ in SQL
Optimizing Oracle SQL Insert Performance
Blocksize and Insert Performance

Oracle Delete Tuning
Using Bulking for Delete Performance

Oracle Update Tuning
CTAS vs. SQL Update statements
Bulking SQL Updates
Bulking SQL Inserts

Oracle tuning with indexes
SQL Tuning with Indexes
The types of Oracle indexes
The Oracle b-tree index
Creating a b-tree index
Does block size matter?

Tuning SQL with bitmapped indexes
Distinct key values and bitmap indexes!

SQL Tuning with bitmap join indexes
How bitmap join indexes work
Bitmap join index example

When Oracle SQL chooses the wrong index
Beware of the fast fix

Forcing index usage
Why doesn’t Oracle use my index?

Using nls_date_format with date indexes

Managing complex date comparisons in SQL
Using the months_between date function
Using the add_months date function
Using the last_day date function
Using the next_day date function
Using the round date function
Using the trunc date function
Index usage and built-in functions
Finding BIF’s
Tuning SQL with Function-based Indexes (FBI)

Using case statements with a function-based index
Indexing on complex functions
Statistics and function-based indexes
Conclusions on function-based indexes

SQL tuning with regular expression indexes
Indexing on regular expressions
Doing case sensitive searches with indexes
SQL Tuning with Oracle*Text Indexes
Oracle Text Index re-synchronization

Tuning SQL with Index Organized Tables
Testing new Oracle indexes
Testing SQL workloads with invisible indexes

Monitoring index usage
Monitoring for Index Range Scans

Monitoring SQL workload activity
Verifying optimal index usage
Finding indexing opportunities
Find SQL that uses sub-optimal indexes
Finding SQL with excessive I/O
Finding sub-optimal SQL in the library cache
Finding index opportunities in AWR
Locating un-used indexes
Finding un-used indexes in Oracle 8i and earlier
Finding un-used indexes in Oracle 9i
Finding un-used indexes in Oracle 10g and beyond

Dropping un-used indexes
Locating infrequently used indexes
The problem of too many indexes
Determining which index to delete
Large Multi-column Indexes

Row clustering and SQL Performance
Index reorganization and SQL Performance
When rebuilding indexes may help SQL performance
When rebuilding indexes will hurt performance
Choosing candidates for index maintenance

Conclusion


Chapter 17:  Oracle Data Warehouse Tuning     

Oracle Data Warehouse Tuning
What Does a Data Warehouse Need?
Oracle star transformations and SQL
Bad star transformation Plan

Why Oracle for the Data Warehouse?
Scaling the Oracle Data Warehouse
Parallel Query for Data Warehouses

Oracle Data Warehouse Tuning TPC-H Benchmarks
Tuning Tricks for Oracle Data Warehouse Configuration

Data Warehouse Design for High Performance
Oracle Data Warehouse Evolution
End-user Query Approach

Data Warehouse Tuning Skills
Data Warehouse Project Manager
The Data Warehouse Informaticist
The Warehouse Statistician
The Data Warehouse Oracle Tuning Professional

Conclusion

Chapter 18:  OEM Tuning 

Introduction to OEM
The New OEM

Tuning with Metrics and Exceptions
Active Session History in Enterprise Manager

Easy Customization of OEM Alerts
Instance Efficiency Metrics
Alerts Notification and Setup

Overview of dbms_scheduler Functions
Throughput Metrics in OEM
OEM Outside the Instance

Exception Tuning Inside Enterprise Manager
Advisor Central in OEM
ADDM Main Screen
ADDM Recommendations

Understanding SQL Advisor Recommendations
The SQL Tuning Advisor Links
The Top SQL Screen
Viewing SQL Details in OEM
The Execution Plan Tab
Current Statistics Tab
Execution History Tab
Tuning History Tab

Oracle SQL Tuning Sets
Creating a SQL Tuning Set
Viewing SQL Tuning Set Details

Using the SQL Access Advisor
New Features of the SQL Advisors
Inside the SQL Access Advisor
The SQL Access Advisor Workload Definition
The SQL Access Advisor Recommendation Options
The SQL Access Advisor Schedule Advisor
The SQL Access Advisor Review
SQL Access Advisor Recommendations

Using the Memory Advisor through OEM
Persistence of Automatically Tuned Values
Automated Maintenance Tasks
Resource Management

Introduction to Online Oracle Tuning Tools
Using Custom Scripts for Oracle Tuning
Shortcomings of OEM
Conclusion 

Chapter 19:  Oracle RAC and Grid Tuning   

Introduction to Tuning with RAC
Oracle RAC in a Nutshell
Oracle Scalability and Grid Technology
First Scale Up with SMP Servers
Next Scale Out with Multiple SMP Servers

Oracle Grid in a Nutshell
Blade Servers and Oracle RAC Tuning
Blade Servers and Oracle App Servers

The Revolution of Cache Fusion
Overview of RAC and Grid Tuning
RAC Load Balancing
Managing Inter-instance Data Block Transfers

Block Spreading
Blocksize Adjustment
Read-only Tablespaces
Parallel Processing and RAC Performance

Conclusion
Index

Posted in Ebooks | Tagged: | 1 Comment »

Database Benchmarking

Posted by ZyK on 12/02/2011

 

ISBN
0-9776715-3-4
ISBN 13
978-0977671533
Library of Congress Number: 2006931339
200 pages
Perfect bind – 9×7
PD 107
Shelving: Database/Oracle   IT in-Focus:
Series # 3
Database Benchmarking
Practical methods for Oracle & SQL Server

Bert Scalzo, Kevin Kline,
Claudia Fernandez
Donald K. Burleson,
Mike AultRetail Price $39.95 /  £27.95

Every information system must know their limits.  As systems grow, resources are stressed and one of the major causes of unplanned database outages is a failure to anticipate the effects of growth.

Benchmarking is a critical job function and every database professional must understand the principles of capacity planning and database bottleneck analysis.  By using a benchmark method you can spot areas of pending problems before they cripple your database.

This landmark book explores all aspects of database benchmarking and shows you a real-world approach that ensures that you are prepared for whatever the future brings to your mission-critical database.

* Know the limits of your database before you hit them

* Avoid unplanned outages with capacity planning

* Learn the exact limits of your transaction rates

* Predict when you will need new hardware

 

About the Authors:

 

Bert Scalzo Bert Scalzo is a Database Expert for Quest Software and a member of the TOAD dev team. He has worked with Oracle databases for well over two decades. Mr. Scalzo’s work history includes time at both Oracle Education and Oracle Consulting. He holds several Oracle Masters certifications and an extensive academic background - including a BS and MS in Computer Science, an MBA, plus insurance industry designations. Mr. Scalzo is also an Oracle ACE.

Mr. Scalzo is accomplished speaker and has presented at numerous Oracle conferences and user groups – including OOW, ODTUG, IOUG, OAUG, RMOUG and many others. His key areas of DBA interest are Data Modeling, Database Benchmarking, Database Tuning & Optimization, “Star Schema” Data Warehouses, Linux and VMware.

Mr. Scalzo has written numerous articles, papers and blogs – including for the Oracle Technology Network (OTN), Oracle Magazine, Oracle Informant, PC Week (eWeek), Dell Power Solutions Magazine, The LINUX Journal, LINUX.com, Oracle FAQ, Ask Toad and Toad World.

Mr. Scalzo has also written six books: Oracle DBA Guide to Data Warehousing and Star Schemas, TOAD Handbook, TOAD Pocket Reference (2nd Ed),Database Benchmarking: Practical Methods for Oracle & SQL Server, Advanced Oracle Utilities: The Definitive Reference and Oracle on VMware: Expert Tips for Database Virtualization.

 

 

 

Posted in Ebooks | Tagged: | Leave a Comment »

SoJungle: AIX documents to share

Posted by ZyK on 11/30/2011

LVM quick reference

News

AIX Logical Volume Manager

Redbooks IBM Links Recommended Links Recommended eBooks and Papers Reference
what disks are in the root volume group How many disks are on the system Create a volume group Add a disk to the root volume group Make sure the disks are in an active state Mirror the logical volumes Create the boot image on the new disk
Extend the size of filesystem Remove a file system JFS mksysb Command Aix JFS2 snapshots Humor Etc

 

Recommended Links

Posted in Shared | Tagged: , | Leave a Comment »

Professional Career Planning

Posted by ZyK on 11/23/2011

Career Planning Chapter Index

Assignment 
Overview
This Career Planning Monograph is designed for those wanting to have a professional process for developing their life/career plan.  The process was developed in a college setting in collaboration with other professionals in an attempt to assist students with a quality career planning tool.  The process will take you about 40 hours to complete and will yield you a great plan for your future, and a strong network of support professionals.  Should the planning for your career/life  take less time than you would put into planning to build a new home?
.
Assignment 
Description:
Upon completion of this career planning module you should be able to develop a professional career plan that includes: career goals, personal assessment, industry based research, educational objectives, work-skill objectives, a functional resume, and material needed to present your career plan to employers and other professionals.
.
Assignment 
Objectives:
Your task with this module will be to read and complete the five chapters of this monograph.  While reading the chapters you will need to complete the worksheets with each assignment.  This process will give you the “big picture” about your professional career.  The process will also provide you with the steps and confidence to seek your dream career.Bookmark this page as it is the chapter index for the course. 
It will also be your entrance each time you return to complete career work.

.

Assignment 
Format:
Read the Professional Career Planning monograph, one chapter at a time, complete the exercises in each chapter.  It is best to complete the chapters in the sequence they are presented, because they build on each other. Good luck and don’t forget to contact us if you have any questions.

(http://mycareerplan.net.)

Posted in .Sojungle News | Tagged: | Leave a Comment »

Troubleshooting Oracle Performance

Posted by ZyK on 11/22/2011

Troubleshooting Oracle Performance

by Christian Antognini

Hardcover or paperback: 616 pages
Publisher: Apress
Publishing date: June 2008
Language: English
ISBN-10: 1-59059-917-9
ISBN-13: 978-1-59059-917-4
ISBN-13 (electronic): 978-1-4302-0498-5

Here you’ll find detailed information about the book, including:

Table of Contents

Part 1 – Foundations

1. Performance Problems

  • Do We Need To Plan Performance?
  • Do We Have Performance Problems?
  • How to Approach Performance Problems?

2. Key Concepts

  • Selectivity and Cardinality
  • Life Cycle of a Cursor
  • How Parsing Works
  • Reading and Writing Blocks

Part 2 – Identification

3. Identifying Performance Problems

  • Divide and Conquer
  • Analysis Roadmap
  • Instrumentation vs. Profiling Analysis
  • Instrumentation
  • Profiling Application Code
  • Tracing Database Calls
  • Profiling PL/SQL Code

Part 3 – Query Optimizer

4. System and Object Statistics

  • Overview of the Package dbms_stats
  • System Statistics
  • Object Statistics
  • Common Services

5. Configuring the Query Optimizer

  • To Configure or Not to Configure
  • Configuration Roadmap
  • Set the Right Parameter!

6. Execution Plans

  • Obtaining Execution Plans
  • Interpreting Execution Plans
  • Recognizing Inefficient Execution Plans

7. SQL Tuning Techniques

  • Altering the Access Structures
  • Altering the SQL Statement
  • Hints
  • Altering the Execution Environment
  • SQL Profiles
  • Stored Outlines
  • SQL Plan Baselines

Part 4 – Tuning

8. Parsing

  • Identifying Parsing Problems
  • Solving Parsing Problems
  • Working around Parsing Problems
  • Application Programming Interfaces

9. Optimizing Data Access

  • Identifying Suboptimal Access Paths
  • SQL Statements with Poor Selectivity
  • SQL Statements with Good Selectivity

10. Optimizing Joins

  • Definitions
  • Nested Loop Joins
  • Merge Joins
  • Hash Joins
  • Outer Joins
  • Choosing Join Method
  • Partition-Wise Joins
  • Transformations

11. Beyond Data Access and Join Optimization

  • Materialized View
  • Result Caching
  • Parallel Processing
  • Direct-path Insert
  • Row Prefetching
  • Array Interface

12. Optimizing the Physical Design

  • Optimal Column Order
  • Optimal Data Type
  • Row Migration and Row Chaining
  • Block Contention
  • Data Compression

Part 5 – Appendixes

A. Downloadable Files

B. Bibliography

Posted in Ebooks | Tagged: | Leave a Comment »

NMON performance: A free tool to analyze AIX and Linux performance

Posted by ZyK on 10/05/2011

Usage notes: This nmon tool is NOT OFFICIALLY SUPPORTED. No warrantee is given or implied, and you cannot obtain help with it from IBM. If you have a question on nmon, please go on the Performance Tools Forum site (see Resources) so that others can find and benefit from the answers. To protect your email address from junk mail, you need to create a USER ID first (takes 20 seconds at most).

The nmon tool runs on:

  • AIX® 4.1.5, 4.2.0 , 4.3.2, and 4.3.3 (nmon Version 9a: This version is functionally established and will not be developed further.)
  • AIX 5.1, 5.2, and 5.3 (nmon Version 10: This version now supports AIX 5.3 and POWER5™ processor-based machines, with SMT and shared CPU micro-partitions.)
  • Linux® SUSE SLES 9, Red Hat EL 3 and 4, Debian on pSeries® p5, and OpenPower™
  • Linux SUSE, Red Hat, and many recent distributions on x86 (Intel and AMD in 32-bit mode)
  • Linux SUSE and Red Hat on zSeries® or mainframe

The nmon tool is updated roughly every six months, or when new operating system releases are available. To place your name on the e-mail list for updates, contact Nigel Griffiths.

Use this tool together with nmon analyser (see Resources), which loads the nmon output file and automatically creates dozens of graphs.

Introduction

The nmon tool is designed for AIX and Linux performance specialists to use for monitoring and analyzing performance data, including:

  • CPU utilization
  • Memory use
  • Kernel statistics and run queue information
  • Disks I/O rates, transfers, and read/write ratios
  • Free space on file systems
  • Disk adapters
  • Network I/O rates, transfers, and read/write ratios
  • Paging space and paging rates
  • CPU and AIX specification
  • Top processors
  • IBM HTTP Web cache
  • User-defined disk groups
  • Machine details and resources
  • Asynchronous I/O — AIX only
  • Workload Manager (WLM) — AIX only
  • IBM TotalStorage® Enterprise Storage Server® (ESS) disks — AIX only
  • Network File System (NFS)
  • Dynamic LPAR (DLPAR) changes — only pSeries p5 and OpenPower for either AIX or Linux

Also included is a new tool to generate graphs from the nmon output and create .gif files that can be displayed on a Web site.

See the README file for more details.

Benefits of the tool

The nmon tool is helpful in presenting all the important performance tuning information on one screen and dynamically updating it. This efficient tool works on any dumb screen, telnet session, or even a dial-up line. In addition, it does not consume many CPU cycles, usually below two percent. On newer machines, CPU usage is well below one percent.

Data is displayed on the screen and updated once every two seconds, using a dumb screen. However, you can easily change this interval to a longer or shorter time period. If you stretch the window and display the data on X Windows, VNC, PuTTY, or similar, the nmon tool can output a great deal of information in one place.

The nmon tool can also capture the same data to a text file for later analysis and graphing for reports. The output is in a spreadsheet format (.csv).

Installing the tool

The tool is a stand-alone binary file (a different file for each AIX or Linux version) that you can install in five seconds, probably less if you type fast. Installation is simple:

  • Copy the nmonXXX.tar.Z file to the machine. If using FTP, remember to use binary mode.
    Note: Version XXX replaces this example.
  • To uncompress the file, run uncompress nmonXX.tar.Z.
  • To extract the files, run tar xvf nmonXX.tar.
  • Read the README file.
  • To start the nmon tool, type nmon.
  • If you are the root user, you might need to type ./nmon.

Extra notes for using nmon 9 for AIX 4 only

  1. You must be the root user or allow regular users to read the /dev/kmemfile by typing the following command (as root):
    chmod ugo+r /dev/kmem
  2. If you want the disk statistics, then also run (as root):
    chdev -l sys0 -a iostat=true

How to run the tool interactively

For running the tool interactively, read the front page of the file for a few hints. Then start the tool and use the one-key commands to see the data you want. For example, to get CPU, Memory, and Disk statistics, start nmon and type:

cmd

 

How to get help information while running interactively

Press the h key.

Additional help information

For additonal help information, try the following:

  • Type the nmon -? command for brief details.
  • Type the nmon -h command for full details.
  • Read the README file.

How to capture the data to a file for later analysis and graphing

Run nmon with the -f flag. See nmon -h for the details. But as an example, try to run nmon for an hour capturing data snapshots every 30 seconds by using:       Â

nmon -f -s 30 -c 120
nmon -fT -s 30 -c 120

 

The second line also captures the top processes. Both of these create the output file in the current directory called:       Â

<hostname>_date_time.nmon

 

This file is in a comma-separated values (CSV) format and can be imported into a spreadsheet directly. If you are using Lotus® 1-2-3, the file needs to be sorted. (This is not required for the Excel version of the nmon analyser.) On AIX, follow this example:       Â

sort -A mymachine_311201_1030.nmon > xxx.csv

 

Notes to save you time:

  • To load the nmon data capture file into a spreadsheet, check the spreadsheet documentation for loading CSV data files (.csv). Many spreadsheets accept this data as just one of the possible files to load or provide an import function to do this. Many spreadsheets have a fixed number of columns and rows. I suggest you collect a maximum of 300 snapshots to avoid hitting these issues.
  • When you are capturing data to a file, nmon disconnects from the shell to ensure that it continues running, even if you log out. This means that nmoncan appear to crash, even though it’s still running in the background. To see if the process is still running, type:
    ps ?ef | grep nmon
  • Read the README file for more information about which version of nmon to run on your particular operating system.
  • nmon Version 10 for AIX 5 no longer uses /dev/kmem, but only public APIs. So, you don’t have to chage the permissions on /dev/kmem, and there is no need to have 32- and 64-bit versions of nmon.
  • For AIX 5.1, 5.2, and 5.3, use nmon 10.
  • On AIX, don’t report lslpp -Lcq bos.?p core dumps on AIX 5.1, about ML03 onwards. Also, WLM stats go missing after upgrading to AIX 5.2 ML5 to Nigel Griffiths, as these are AIX bugs. These are avoided by using nmon Version 10.
  • Don’t use Microsoft® Windows® Telnet and use a larger window than 80 x 25 characters. Many developers use VNC and PuTTY to display nmon from a Windows machine — why not do the same!

New features for nmon on AIX Version 10

New Features Description
Starting up There is also now a small shell script called "nmon" that starts the right nmon version. Place this script and nmon binaries in your $PATH and type: nmon. This version is now only compiled in 32-bit mode. So, it runs on 32- and 64-bit hardware. The idea is to make it easier to install and run.
N = NFS NFS is completely new for nmon 10.
p = Partitions This is for shared CPU partitions information — the big p5/AIX5.3 feature.
C = CPU This is for machines with 32 plus CPUs — up to 128 logical CPUs by demand.
c = CPU Details your physical CPU use — if you are on a POWER5 with AIX 5.3 and in a shared CPU environment.
S = Subclass This is for WLM subclasses — by request.
a = Disk adapters Gives you details of the disk adapter — like their full type.
r = Resources This includes your CPU speed in MHz.
k = Kernel Gives some new fields.
L = Large pages Gives you large-page stats — popular with high-performance guys.
D = Disk Gives you more information about your disks, disk type sizes, free, volume groups, adapter, and so forth.
n = Network Gives you information about your network adapters details, MTU, and errors.
m = Memory Gives you more details on where your memory is going, system (kernel) and processes, and active virtual memory.
-B This is a start-up option to remove the boxes.

Sample output for nmon 10 for AIX 5

Figure 1 below is a sample of the screen output. It shows the opening screen for AIX 5, with lots of useful information.
Figure 1. Sample output for nmon 10 for AIX 5
Screen shot of AIX 5 opening                                                         screen

Figure 2 illustrates the details for CPU (this is a 4 CPU POWER5 machine with SMT switched on), memory use, kernel internal statistics, and disks statistics. Note: This logical partition (LPAR) is using six times its entitlement in half a CPU.
Figure 2. CPU details
Screen shot of                                                                     CPU details

Figure 3 shows the details of the network, NFS statistics, and journal filesystem use.
Figure 3. Network details
Screen                                                                                 shot of                                                                                 network                                                                                 details

The details of the POWER5 shared processor micro-partitions statistics are shown in Figure 4 below.
Figure 4. LPAR details
Screen                                                                                            shot                                                                                            LPAR                                                                                            details

Figure 5 illustrates the details of the Linux version of nmon, showing the CPU (this is a 2 CPU POWER5 machine with SMT switched on), LPAR statistics, memory use, network statistics, file system use, and disks statistics. Note: The physical CPU of this LPAR is only available with SUSE SLES9 Service Pack 1 and Red Hat EL 4 Update 1.
Figure 5. Linux version of nmon
Screen shot of details of the Linux version of nmon

Figure 6 shows the OS details of the machine, disk statistics (detailed mode), and the top processes.
Figure 6. Linux version of nmon continued
Screen shot of Linux OS details of the machine

Obtaining the tool

The following download options are available:

 

Resources

Learn

Get products and technologies

  • IBM trial software: Build your next development project with software for download directly from developerWorks.
  • nmon: Download nmon and its tools.

Discuss

About the author

Nigel Griffiths works in the IBM eServer® pSeries Technical Support Advanced Technology Group. He specialises in performance, sizing, tools, benchmarks, and Oracle RDBMS. The nmon tool was developed to support benchmarks and performance tuning for internal use, but by popular demand is given away to deserving friends. If you have a question on nmon, please go on the Performance Tools Forum site (see Resources) so that others can find and benefit from the answers. To protect your email address from junk mail, you need to create a USER ID first (takes 20 seconds at most).

Greetings, please note if you used nmon_grapher script for producing nmon outputs on AIX 5.3 and now migrated to AIX 6.1 the script needs adjustment because of the change in TZ variable
AIX 5.3: CET-1CEST,M3.5.0,M10.5.0/03:00
AIX 6.1: Europe/Prague
As the script derives next starting time from the value -1 in older TZ format, it won’t work on 6.1 because it wouldn’t choose next starting time for data collection in the at job correctly.

from IBM.com

Posted in Tools, UNIX-LINUX | Tagged: , | 1 Comment »

USB Safeguard

Posted by ZyK on 07/21/2011

USB Safeguard

USB Safeguard is a freeware files encryption utility, small, portable and easy to use.

Simply drag and drop files and folders to quickly protect your sensitive documents, and then enter an password to encrypt and decrypt the files that you want to protect from prying eyes.

Not only encrypts your files, it also has ‘Safe Internet Browsing’ option to surf safe on web and removes all Internet traces like URL history, typed URLs, typed passwords in web forms and etc. Built in file shredder – i.e. wiping the contents of the original pre-encrypted file – and more.

Your data is secure while the drive it is out and about with you in an Internet cafe’s or at work.

Main Features:

  • Runs with any usb pen drive
  • No installation required
  • Easy drag & drop file adding
  • Built in file shredder
  • Secure your data if drive is lost

Posted in Tools | Tagged: | Leave a Comment »

Flexcrypt – Encrypt Your Private Data with a Password

Posted by ZyK on 07/21/2011

Flexcrypt
Flexcrypt Folder enables you to encrypt a file or a folder. After installation, right-click on a file/folder and select Encrypt with Flexcrypt folder and make up a password, thats it.

Decryption is done by double-clicking on the encrypted file and enter the correct password.

The BIG advantage with Flexcrypt Folder is that it does not require any software to decrypt an encrypted file, just double-click on the file and specify the correct password.

How to send an encrypted file/folder:
In some cases it is necessary to rename the encrypted file (take away .exe ending) in order for the file to go through firewalls.
Rename the encrypted file by:
· Right-click on the encrypted file and choose Rename
· Take away .exe at the end of the filename
· Encrypted file is now ready to be sent
The receiver must also rename the file back to its original ending by:
· Right-click and choose Rename
· Add .exe at the end of the filename

You might also like:

Posted in Tools | Tagged: | 1 Comment »

Oracle Database 10g High Availability with RAC, Flashback, and Data Guard

Posted by ZyK on 07/19/2011

Product Description
Attain real solutions for current availability challenges. Based on a “DBA-centric” approach to High Availability, Oracle Database 10g High Availability concentrates on explaining Oracle Database 10g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and recovery, and distributed database solutions. Hardware and application needs are also taken into account. While Oracle Database 10g is the main focus, many of the options discussed are available in earlier database releases. Organized to provide conceptual understanding of High Availability, included are “HA Workshops,” step-by-step instructions to get you through certain implementations, plus real-world inspired case studies.

Part I – Logical Availability
Chapter 1 – Oracle and Availability: Illustrated Downtime Scenarios
Chapter 2 – RDBMS Features for Availability
Chapter 3 – Tuning Your Database for Availability

Part II – Real Application Clusters
Chapter 4 – RAC Setup and Configuration
Chapter 5 – Database Administration in a RAC Environment
Chapter 6 – Utility Computing: Applications as Services

Part III – Disaster Planning
Chapter 7 – Oracle Data Guard: Surviving the Disaster
Chapter 8 – Backup and Recovery for High-Availability Environments
Chapter 9 – Oracle Flashback: Surviving User-Induced Trauma

Part IV – Distributed Database Solutions
Chapter 10 – Oracle Streams for High Availability
Chapter 11 – Oracle Net Configuration for Failover

 

Posted in Ebooks | Tagged: , , , , | 2 Comments »

 
Follow

Get every new post delivered to your Inbox.