Oracle Exadata datafile distribution

exadataoracleoracle-11g-r2

I'm new to Oracle and curious of how Oracle Exadata handles database files. Do we have to assign the disk to a database file as we do with Microsoft or is this handled by Exadata?

Best Answer

I do not know what you mean by the "Microsoft" way, but Exadata uses ASM.

Administering Oracle ASM Disk Groups on Oracle Exadata Storage Servers

http://www.oracle.com/technetwork/database/availability/maa-exadata-upgrade-asm-2339100.pdf

ASM is not specific to Exadata or any hardware, you can use it on any supported platform, even on Windows, so you handle database files just as in any other environment with ASM.

Related Solutions

Strange behaviour of a query with order by and rownum on Oracle’s Exadata server

This answer is wrong, because the value for rownum is assigned before the order by is executed.

Below is the correct one,

SELECT start_date,  
       end_date,  
       resort_id,  
       ROWNUM  
FROM   (SELECT   start_date,  
                end_date,  
                resort_id  
       FROM     employee_activity  
       WHERE    employee_id = 27  
       AND      start_date < TO_DATE ('2012-11-09', 'YYYY-MM-DD')  
       AND      is_overridden = 1  
       ORDER BY start_date DESC
      )  
WHERE  ROWNUM = 1

Exadata exachk.sh

Yes, it is possible. You can run exachk.sh -s To get it work you have to setup first the SSH user equivalence for database users.

You can find here more infos: Run the Exachk Tool Automatically on Exadata

Best Answer

Related Solutions

Strange behaviour of a query with order by and rownum on Oracle’s Exadata server

Exadata exachk.sh

Related Question