Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: how to create script for this formula?
Top Forums Shell Programming and Scripting how to create script for this formula? Post 302314638 by ghostdog74 on Saturday 9th of May 2009 05:56:28 AM
Old 05-09-2009
if you have Python, here's an alternative
Code:
d={}
for line in open("file"):
    line=line.strip().split(" = ")    
    d[line[0]]=int(line[1])

calculation = 1 - ((d["Buffer pool data physical reads"] + 
d["Buffer pool xda physical reads"] + 
d["Buffer pool index physical reads"] + 
d["Buffer pool temporary data physical reads"] + 
d["Buffer pool temporary xda physical reads"] + 
d["Buffer pool temporary index physical reads"] ) / (d["Buffer pool data logical reads"]+
 d["Buffer pool xda logical reads"] + d["Buffer pool index logical reads"] +
 d["Buffer pool temporary data logical reads"] + 
d["Buffer pool temporary xda logical reads"] + 
d["Buffer pool temporary index logical reads"] )) * 100
print calculation

similar, it can be done with awk. split on "=" using FS, then get them into associative arrays. then do the calculation.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Quadratic Formula Program

I have a question about the program I am making. I finished it, compiled it, and there were no errors. Now when I run it, the comand prompt comes up and there are just 1's and 0's that keep looping over and over again. The program is listed before. If anyone has any suggestions I would greatly... (2 Replies)
Discussion started by: zeek
2 Replies

2. Shell Programming and Scripting

Help with formula in a script

I need some help. I been doing system admin for the last several years and gotten very rusty on scripting. I need to write a script that will take a log entry and do math using two columns of data to create a new column. I am taking the column(#2) that contains the time and the column(#5) that... (3 Replies)
Discussion started by: scottzx7rr
3 Replies

3. Solaris

formula to get the swap space on a machine

Hello there are different opinions on how to get the swap space on Solaris. some say: swap -s and the space= used + available others say swap -l (donno how they get the swap size) other say 'top' command others say using format command (in print sub-command) Could you please advise on... (1 Reply)
Discussion started by: melanie_pfefer
1 Replies

4. UNIX for Dummies Questions & Answers

Formula help

The formula below will calculate a distance in miles between 2 points in excel. Can some put it to work in unix? Lat = 43.335 Lon1 = -70.9884 Lat2 = 43.4829 Lon2 = -71.246 distance... (8 Replies)
Discussion started by: bobo
8 Replies

5. Shell Programming and Scripting

Formula to get combination… sum

Formula to get combination Lats say, I have 5 values ID Price 1 5 2 10 3 30 4 5 Resule with Possible combinations will be ID Price 1 5 2 10 3 30 4 5 1+1 10 1+2 15 1+3 35 1+4 10 (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies

6. Homework & Coursework Questions

Create script to add user and create directory

first off let me introduce myself. My name is Eric and I am new to linux, I am taking an advanced linux administration class and we are tasked with creating a script to add new users that anyone can run, has to check for the existence of a directory. if the directory does not exist then it has... (12 Replies)
Discussion started by: pbhound
12 Replies

7. Shell Programming and Scripting

Convert Formula to Value

I'm new to Perl, but I need to use it to write into an excel spreadsheet. I want to copy the values of certain cells into a new sheet in the workbook. I'm unsure of how to do this because I don't know how to copy values instead of formulas. Note: by formula I mean '=SUM(A1,A2)' and by value I... (0 Replies)
Discussion started by: AgentSmith88
0 Replies

8. Shell Programming and Scripting

formula missing in excel after using perl

Dear all, I got a template excel file which contains several worksheets. Each worksheet contains some formulas in the cells. I am using the perl script to read a CSV file and then put the data of CSV into template excel file(first worksheet) and then save it as new file name using ... (0 Replies)
Discussion started by: eldonlck
0 Replies

9. Shell Programming and Scripting

Formula missing in excel after using perl

Hi all, I use "Spreadsheet::ParseExcel::SaveParser" to - read a existing excel file with : $Parser = Spreadsheet::ParseExcel::SaveParser->new(); $HeaderFile = $Parser->Parse("XLS_FILE_ACCESS"); - modify some values in somes cell with : $worksheet->AddCell($row_target,$col_max,... (3 Replies)
Discussion started by: Yom
3 Replies

10. Shell Programming and Scripting

A strange formula

Dear Masters, Kindly need your helps for this issue.. I face a formula as a picture... the input file is A DEPT Vp Vs rho VPperVS ------------------------ ------------ ------------ ------------ 700 151.9218 121.9269 ... (11 Replies)
Discussion started by: ipatah
11 Replies

LEARN ABOUT SUNOS

asadmin-ping-connection-pool

asadmin-ping-connection-pool(1AS)				   User Commands				 asadmin-ping-connection-pool(1AS)

NAME

       asadmin-ping-connection-pool, ping-connection-pool - tests that a connection pool is usable

SYNOPSIS

       ping-connection-pool --user admin_user [--password admin_password] [--host localhost] [--port 4848] [--secure|-s] [--passwordfile filename]
       [--terse=false] [--echo=false] [--interactive=true] pool_name

       Tests that a connection pool is usable for both JDBC connection pools and connector connection pools. For example, if you create a new JDBC
       connection  pool for use with an application that is expected to be deployed, before deploying the application, the previously created pool
       is tested with this command.

       This command is supported in remote mode only.

OPTIONS

       --user		       authorized domain application server administrative username.

       --password	       password to administer the domain application server.

       --host		       machine name where the domain application server is running.

       --port		       port number of the domain application server listening for administration requests.

       --secure 	       if true, uses SSL/TLS to communicate with the domain application server.

       --passwordfile	       file containing the domain application server password.

       --terse		       indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
			       formatted data for consumption by a script. Default is false.

       --echo		       setting to true will echo the command line statement on the standard output. Default is false.

       --interactive	       if set to true (default), only the required password options are prompted.

OPERANDS

       poolname 	       name of the connection pool to be tested.

       Example 1: Using ping-connection-pool

       Before you can ping a connection pool, you must:

	 o  Create a connection pool with authentication.

	 o  Make sure the Enterprise Information Server (can be the database) is started.

       asadmin> ping-connection-pool --user admin1 --password adminadmin1
       --host pigeon --port 5001 sampleConnectionPool
       Command ping-connection-pool executed successfully

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-create-connector-connection-pool(1AS),  asadmin-delete-connector-connection-pool(1AS), asadmin-list-connector-connection-pool(1AS),
       asadmin-create-jdbc-connection-pool(1AS), asadmin-delete--jdbc-connection-pool(1AS)asadmin- list--jdbc-connection-pools(1AS)

J2EE 1.4 SDK							    March 2004					 asadmin-ping-connection-pool(1AS)
All times are GMT -4. The time now is 03:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy