Skip to Main Content
Forums

Hardware

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

RAID 5 raidctl -- operation not support with volume of this level

807557Sep 12 2008 — edited Nov 13 2009
How can I make a RAID-5 with 6 disks?

raidctl -c -r 5 c1t2d0 c1t3d0 c1t4d0 c1t5d0 c1t6d0
Creating RAID volume will destroy all data on spare space of member disks, proceed (yes/no)? yes
Operation not support with volume of this level.

I'm not sure what the message "Operation not support with volume of this level" means or how to fix it.

Comments

Tomasz K.

Just simply divide bytes by 1024/1024/1024:

SELECT a.TABLESPACE_NAME, 
Round(a.BYTES/1024/1024/1024,3) gigabytes_used, 
Round(b.BYTES/1024/1024/1024,3) gigabytes_free, 
Round(b.largest/1024/1024/1024,3), 
ROUND(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used 
FROM 
( 
SELECT TABLESPACE_NAME, 
SUM(BYTES) BYTES 
FROM dba_data_files 
GROUP BY TABLESPACE_NAME 
) 
a, 
( 
SELECT TABLESPACE_NAME, 
SUM(BYTES) BYTES , 
MAX(BYTES) largest 
FROM dba_free_space 
GROUP BY TABLESPACE_NAME 
) 
b 
WHERE a.TABLESPACE_NAME=b.TABLESPACE_NAME 
ORDER BY ((a.BYTES-b.BYTES)/a.BYTES) DESC;
571482
1 gigabyte = 1024 ^3 bytes = 1 073 741 824 bytes

so -
a.bytes bytes_used
can become
a.bytes/1073741824 gigabytes_used
Laurent Schneider
In storage, it is common sense to say 1GB = 1e6 bytes

http://wapedia.mobi/en/Giga

I first thought it was a marketing trick to sale 0.976 Gibibytes to the price of 1G, but it seems hard disk vendors always preferred decimal systems.
Rob van Wijk
Laurent Schneider wrote:
In storage, it is common sense to say 1GB = 1e6 bytes
Or even more common sense to say 1GB = 1e9 bytes ;-)

Regards,
Rob.
Frank Kulash

Hi,

Instead of saying

x / 1024 / 1024 / 1024

you can say

x / POWER (2, 30)

or

x / POWER (1024, 3)

I define a substitution variable in my LOGIN.SQL file.

1 person found this helpful
571482
So if I have 1GB table on disk, it actually takes slightly less than 1GB of memory once I read it into SGA?
William Robertson
Just for fun, if this were PL/SQL instead of SQL, you could also use
1024**3
or even
2**30
@user619226:

{noformat}>{noformat} HOW DO I MAKE IT TO see in Gigabytes?

Look up "Gigabyte" in a dictionary and divide the bytes figure by that number? Apologies if I am missing something.
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 11 2009
Added on Sep 12 2008
#storage, #storage-general-discussion
4 comments
339 views