datafile header on row devices [message #130197] |
Thu, 28 July 2005 12:52 |
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 |
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 |
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 |
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 #130951 is a reply to message #130197] |
Wed, 03 August 2005 09:56 |
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 |
|
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 |
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 |
|
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.
|
|
|