شابا إيش الفرق عند تنزيل قاعدة البيانات وإختيار طريقة التخزين

File system

ASM Automatic Storage Management

 

ممكن أحد يشرحلي ويفهمني إيش الفرق

 

If your database is for test , so keep it on filesystem , same harddisk , but if it's Life prodution database so Better to keep your data in ASM , for easy maintainance in future ,

Ex: if you need to increase disk space , just mount the new harddisk and add it in diskgroup

 

and also ASM has feature of Mirroring to protects your data by storing copies of data on multiple disks.

 

Reference :-

http://docs.oracle.com/cd/B28359_01/server.111/b31107/asmcon.htm#OSTMG036

 

Regards

 

Thank you Mr. mody82 for your Answer.

I have one question,if I have 2 users trying to update the same record and not commite,that mean Oracle will make lock until one of them commit or rollback.

if I want to know who are those users and what is the record.

my question from which tables I can see this?

Dear Mr AAZH ,

 

to answer ur question about ASM and File system in a simple way Kindly note that :

File System : Oracle will use the ordinary (windows / unix ) file system to store  its data files  , that mean u can deal with this files with  operating system commands u can copy , cut , paste  , delete as it is normal system files , its suitable for small databases where files kept on one hard disk and no need to implement mirrors and redundancy and its suitable for  large databases if u can effort SAN Storage  

ASM : it ease the Maintenance and Administration , as u let oracle handle all the data files administration and space administration tasks , 

also implementing ASM in huge databases will give u up to 30 % boost in performance and it will auto implement mirrors and redundancy but U CANNOT use operating system commands to deal with data files any more 

one of the disadvantages of ASM that the only way to backup its file is using RMAN , u cant use operating system copy or third party apps to backup ASM , however some third party apps such as veritas Netbackup allow u to write a script that hock into RMAN and backup the database using veritas GUI

Dear Mr AAZH

for locks Kindly try this query 

select

   c.owner,

   c.object_name,

   c.object_type,

   b.sid,

   b.serial#,

   b.status,

   b.osuser,

   b.machine

from

   v$locked_object a ,

   v$session b,

   dba_objects c

where

   b.sid = a.session_id

and

   a.object_id = c.object_id;

شكرا لكل الردود ...... الي الامام