SAN related information from oracle?

Adil Rehman Oct 21, 2016 7:06 AM

Hi experts,

Can i get following information via Oracle?

1. Are you using SAN for storage?

2. What is RAID Type ?

3. How many physical disks are configured ?

4. What is RPM of these disks?

5. What is IOPS?

6. What is throughput ?

Thanks in Advance.

1. Re: SAN related information from oracle?

JohnWatson2 Oct 21, 2016 7:27 AM (in response to Adil Rehman)

5 and 6 can be determined by using DBMS_RESOURCE_MANAGER.CALIBRATE_IO because they give the CBO usefull information. I do not see why the database would need to know 1 through 4, what is the reason?
Like Show 1 Likes(1)

Actions
2. Re: SAN related information from oracle?

EdStevens Oct 21, 2016 12:22 PM (in response to Adil Rehman)

Also asked at OraFAQ Forum: Linux » How to know SAN related info from linux?
Like Show 0 Likes(0)

Actions