find the size of a database by counting all the used pages

family_guy · #1 (**permalink**) 03-10-2009

Hi all,

I am looking to find the size of the database by counting all the used pages.

1. I have a file which reads like below
16384 4750850
32768 165
The first column is the pagesize and the second column is the number of pages associated.

So what i am trying is to do is read the file and put the values in 4 variables A,B,C,D....if A = 16384 then E = $A * $B(4750850)

So how do i read 16384 into A and so on....

thanks in advance

R.T. · #2 (**permalink**) 03-10-2009

Are you familiar with awk?
You could try

Code:

awk '{print $1" x "$2" = "$1*$2}' filename

$1 would be the first field, $2 would be the second, etc.

family_guy · #3 (**permalink**) 03-10-2009

can you guide me in reading those values into variables...like putting 16384 into A and 32XXX into B etc

R.T. · #4 (**permalink**) 03-10-2009

Code:

awk '{A=$1;B=$2;print A" x "B" = "A*B}' filename

family_guy · #5 (**permalink**) 03-10-2009

How can i get the grand total?

awk '{A=$1;B=$2;print A" x "B" = "A*B}' out
16384 x 4750850 = 7.78379e+10
32768 x 165 = 5406720

Looking for a total ( 7.7XXXX + 5406720)

R.T. · #6 (**permalink**) 03-10-2009

Code:

awk '{A=$1;B=$2;C=C+A*B;print A" x "B" = "A*B};END{print "Total = "C}' filename

family_guy · #7 (**permalink**) 03-10-2009

you rock bud...thnx a ton

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
know the size of database	megh	HP-UX	1	07-19-2008 08:06 AM
Recursively find and change Permissions on Man pages	altamaha	Security	5	03-25-2008 06:00 AM
command to find out total size of a specific file size (spread over the server)	abhinov	SUN Solaris	3	08-08-2007 06:48 AM
command(s) to find size of mysql database?	sbourgeois	UNIX for Dummies Questions & Answers	4	06-12-2006 12:40 AM
database image size	ppass	SUN Solaris	6	05-31-2005 08:48 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: