topic Re: file size in Operating System - HP-UX

file size

Ali Saleh_1 — Tue, 09 Sep 2008 08:59:47 GMT

High all;

Please help explaining this odd files sizing..!!

Server: 9000/800/rp7420
OS: HP-UX 11.11
OS mode: 64 bit

$ ls -l shows the file size(TEMP_03.dbf) in bytes as:

-rw-r----- 1 oraprod dba 4194312192 Sep 9 11:38 TEMP_01.dbf
-rw-r----- 1 oraprod dba 4194312192 Sep 9 11:38 TEMP_02.dbf
-rw-r----- 1 oraprod dba 4194312192 Aug 31 08:32 TEMP_03.dbf

$ ls -s shows the file size(TEMP_03.dbf) in 512 byte block as:

8189632 TEMP_01.dbf
8189232 TEMP_02.dbf
144 TEMP_03.dbf

The file is one of oracle temp tablespace data files.

most of the other OS commands like bdf, du, df are follows the "ls -s" sizing. only the backup utility(data protect) is with "ls -l" sizing.

Re: file size

Steven E. Protter — Tue, 09 Sep 2008 09:33:49 GMT

Shalom,

ls -s if you check the man page lists size in BLOCKS, not bytes.

Blocks contain more than one byte.

SEP

Re: file size

Duncan Edmonstone — Tue, 09 Sep 2008 09:52:49 GMT

SEP,

Yes I think he knows this - it is in fact in 512 byte blocks - 512 * 8189632 = ~4194312192

Ali,

Oracle temporary files are sparse files - that means that when created they are most just zeros (null), so there's no point in filling the disk with them. As the file is used, the size reported by "ls -s" will increase, although its interesting that this temporary file has a different access time from the others - I wonder if your DBAs assigned it and then later dropped it?

If you have a support contract associated with your ITRC account you can learn more about sparse files here:

http://www12.itrc.hp.com/service/cki/docDisplay.do?docLocale=en&docId=emr_na-c00904948-7

HTH

Duncan

Re: file size

Ali Saleh_1 — Wed, 10 Sep 2008 09:18:22 GMT

Hi Duncan, SEP

Thank you for your early reply..

We have "HP Support Plus 24 Service" attached to our ITRC ID and still we can not access a lot of ITRC docs,
can you please mail the documment to me ali.saleh@aljomaihauto.com

Regards

Ali Saleh

Re: file size

Dennis Handly — Wed, 10 Sep 2008 10:04:05 GMT

>can you please mail the document to me ali.saleh@aljomaihauto.com

Duncan can not, that is asking him to violate the law in front of the district attorney.

You could try asking the Response Center to make you a copy?

Re: file size

Robert-Jan Goossens_1 — Wed, 10 Sep 2008 10:17:29 GMT

Ali Saleh,

If you have a support contract attached to this server, find the serial number of the server and add this to your ITRC account.

go to;

Â» my profile
Â» link a warranty to your user ID

Regards,
Robert-Jan

Re: file size

Ali Saleh_1 — Wed, 10 Sep 2008 10:34:49 GMT

Robert

All our SIDs are linked to our ITRC ID, but still we have this "Technical knowledge base" documents accessing issue. we logged case with hp and it is a year now since this case is open.

Re: file size

Ali Saleh_1 — Tue, 16 Sep 2008 07:20:06 GMT

Thanks to all,