Home » RDBMS Server » Server Administration » datafile header on row devices
datafile header on row devices [message #130197] Thu, 28 July 2005 12:52 Go to next message
mjschwenger
Messages: 137
Registered: July 2005
Location: US
Senior Member
I'm using row devices Ora 10.1.0.4, aix5.2.
My devices are RAID1, 8G each, and on each one I have 1 datafile of 8G size. I read yesterday that this is worng as I need to leave some space for the datafile header to be located there as well.
Well, when configuring I went through a lot of row device info, and did not see anything like this... I did not get any error when configuring the datafiles and adding them to the tablespaces.
Is this statement true, and if - yes - does this reflect my performance? Does Ora 10g handle this differently then the previous versions, and do I need to make changes in my config?
Any idea ig greatly appreciated.
Thanks, mj
Re: datafile header on row devices [message #130198 is a reply to message #130197] Thu, 28 July 2005 12:54 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Is a "row device" something to do with ASM?

If not, then do you mean something like this:
MYDBA@ORCL > create tablespace test datafile 'e:\oracle\product\10.1.0\oradata\orcl\test.dbf'
  2  size 10m;

Tablespace created.

MYDBA@ORCL > select sum(bytes)/1024/1024 from dba_free_space
  2  where tablespace_name = 'TEST';

SUM(BYTES)/1024/1024
--------------------
              9.9375

1 row selected.

MYDBA@ORCL > select sum(bytes) from dba_segments where tablespace_name = 'TEST';

SUM(BYTES)
----------


1 row selected.

MYDBA@ORCL > select bytes from dba_segments where tablespace_name = 'TEST';

no rows selected

MYDBA@ORCL > select bytes from dba_extents where tablespace_name = 'TEST'
  2  ;

no rows selected

MYDBA@ORCL > select (10-9.9375)*1024*1024 from dual;

(10-9.9375)*1024*1024
---------------------
                65536

1 row selected.

[Updated on: Thu, 28 July 2005 13:03]

Report message to a moderator

Re: datafile header on row devices [message #130202 is a reply to message #130197] Thu, 28 July 2005 14:24 Go to previous messageGo to next message
mjschwenger
Messages: 137
Registered: July 2005
Location: US
Senior Member
No ASM.
Th guy who created them did that in installation time (or post install). Later he added some more using EM to the Users tablespace.
So, for USERS tablespace I have 1 datafile in the installation directory (which I'm goign to empty and remove!), and 8 additional datafiles each on a separate LUN. My question is about each of these datafiles of 8G - is it wrong for them to be with the size of the row device?
I still have a lot of space...
Thanks,mj
Re: datafile header on row devices [message #130330 is a reply to message #130197] Fri, 29 July 2005 07:15 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I'm not totally sure I'm following you yet, but from what I can tell, I don't think you have a problem. The header will be taken out of the datafile. So if you make an 8gig datafile, the actual size of the file will actually be 8gig, it will not be 8gig plus extra for the header. So if you have 8 gig of space on your os disk system, and you make an 8 gig file, then you will be fine from an oracle perspective. Oracle will create header information within that 8 gig, leaving you with 7.something gig available to store table and index data.
Re: datafile header on row devices [message #130334 is a reply to message #130330] Fri, 29 July 2005 07:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
mjschwenger,
Forgive my ignorance.
Are you talking about a raw device/LUN configuration for an oracle database?
Re: datafile header on row devices [message #130342 is a reply to message #130197] Fri, 29 July 2005 08:00 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
raw device, not row. of course...why didn't I see that.
Re: datafile header on row devices [message #130951 is a reply to message #130197] Wed, 03 August 2005 09:56 Go to previous messageGo to next message
mjschwenger
Messages: 137
Registered: July 2005
Location: US
Senior Member
I appologize for my spelling - I just did not see it... this is not my strong side anyway...
I read a couple of Oracle technical notes in Metalink for set up datafiles on RAW (don't mess it up this time) devices. They all say that I need to leave at least 1 to 2 data blocks empty space difference between the size of the RAW device and the datafile placed on it. Assuming because of the datafile header.
But I cannot find information if this will reflect my performance if it has been already set up this way.
Like: Raw device 8G and datafile on if of 8G.
Where can I find more information about?
Also, what will be the most effician way to try to correct the setup done 2 years ago? Resize datafiles?
Aany idea is greatly appreciated.
Thanks,mj
Re: datafile header on row devices [message #130955 is a reply to message #130951] Wed, 03 August 2005 10:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Like: Raw device 8G and datafile on if of 8G
CHeck it out.
It will NOT be like that.
Usually we reserve some space for header
so if the datafile is 8gb then (my) convention is to a partition of size 8gb+1mb.
You cannot create a datafile of 8gb on a partition of 8gb ( you will need some addtional space)
If you are not using this 8gig slice, then you can resize the datafile, move it to another partition of lesser size, drop the old partition.

[Updated on: Wed, 03 August 2005 10:15]

Report message to a moderator

Re: datafile header on row devices [message #130992 is a reply to message #130955] Wed, 03 August 2005 14:44 Go to previous messageGo to next message
mjschwenger
Messages: 137
Registered: July 2005
Location: US
Senior Member
How come Oracle doesn't give an error then?
One of my colleagues created these raw devices, and made a brand new ORA installation on these devices. He also created all new datafiles of 8G on each raw device of 8G. There was no error at this time or later...
Is this going to affect the performance - this is the most improtant question for me as I make a new base line on this server... You could imagine how improtant is this. And I cannot make changes till the test is over!!!
Thanks a lot,mj
Re: datafile header on row devices [message #130994 is a reply to message #130992] Wed, 03 August 2005 14:58 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you check the actual file size and actual partition size?
see session.
i created a partition of 33m.
I cannot create a datafile of 33m.
I can create when size is less than 33m.
dbadmin@xxx > create tablespace test datafile '/dev/vx/rdsk/dev/scid_junk' size 33m;
create tablespace test datafile '/dev/vx/rdsk/dev/scid_junk' size 33m
*
ERROR at line 1:
ORA-01119: error in creating database file '/dev/vx/rdsk/dev/scid_junk'
ORA-27042: not enough space on raw partition to fullfill request
Additional information: 1


dbadmin@xxx > create tablespace test datafile '/dev/vx/rdsk/dev/scid_junk' size 32m;

Tablespace created.


>>Is this going to affect the performance
No direct effect.

Previous Topic: How do I access Oracle database from Linux?
Next Topic: Oracle for windows and linux
Goto Forum:
  


Current Time: Fri Jan 10 08:49:45 CST 2025