ORACLE DBA

Welcome to ASM Configuration Assistant Oracle ASM Configuration Assistant (ASMCA) supports installing and configuring Oracle ASM instances, Oracle ASM disk groups, Oracle ASM Dynamic Volume Manager (Oracle ADVM) volumes and Oracle Automatic Storage Management Cluster File System (Oracle ACFS) file systems. In addition, you can use the ASMCA command line-line interface. Oracle ASM Configuration Assistant enables you to: Manage disk groups Create, configure or drop an Oracle ASM disk group Add disks to and drop disks from the disk group Edit the disk group attributes Manage templates for the disk group Create an Oracle ACFS file system on the disk group for database use Mount or dismount the disk group Add, list or drop quota groups Add, move or drop file groups Manage Oracle ADVM volumes Create or configure an Oracle ADVM volume Enable or disable Oracle ADVM volume View status details Resize or delete volumes Manage Oracle ACFS file systems Create or configure an Oracle ACFS file sy

Exploration of ERP Modules in Oracle E-Business Suite ERP stands for enterprise resource planning. It refers to the systems and software packages used by organizations to manage day-to-day business. Oracle E-Business Suite is one of the most reputed ERP product which is currently available in the market – developed by Oracle. In the world of enterprise resource planning, very few software products have really made to the top ranks when it comes to worldwide implementations. Based on market share – SAP, Microsoft Dynamics are the close vendors who try to get the ERP share in almost all the regions. What is Oracle E-Business Suite? Oracle’s E-Business Suite (also known as Applications/Apps or EB-Suite/EBS) consists of a collection of enterprise resource planning (ERP), customer relationship management (CRM), and supply-chain management (SCM) computer applications either developed or acquired by Oracle. Top Vendors in the market Based on market share – SAP, Oracle, and Microsoft D

-------------------------At Oracle--------------------------------------------------- PREREQUEST: 1.In a database all schema size: set linesize 150 set pagesize 5000 col owner for a15 col segment_name for a30 col segment_type for a20 col TABLESPACE_NAME for a30 clear breaks clear computes compute sum of SIZE_IN_GB on report break on report select OWNER,sum(bytes)/1024/1024/1000 "SIZE_IN_GB" from dba_segments group by owner order by owner; 2.issuing below script you will extract the size & path of datafiles along with tablespace name,allocated space in GB, used space in GB & free space in GB. set linesize 200 set pagesize 2000 COLUMN tablespace_name format a10 COLUMN file_name format a45 COLUMN free% format a7 SELECT df.tablespace_name,SUBSTR (df.file_name, 1, 60) file_name, df.bytes/1024/1024/1024 allocated_GB, round(((df.bytes/1024 /1024/1024) – NVL(SUM(dfs.bytes)/1024/1024 /1024, 0)),1) used_GB, round(NVL(SUM (dfs.bytes)/1024/1024/1024, 0),2) free_space_GB FROM dba_

@ Oracle  PREREQUEST: 1.In a database all schema size: set linesize 150 set pagesize 5000 col owner for a15 col segment_name for a30 col segment_type for a20 col TABLESPACE_NAME for a30 clear breaks clear computes compute sum of SIZE_IN_GB on report break on report select OWNER,sum(bytes)/1024/1024/1000 "SIZE_IN_GB" from dba_segments group by owner order by owner; 2.issuing below script you will extract the size & path of datafiles along with tablespace name,allocated space in GB, used space in GB & free space in GB. set linesize 200 set pagesize 2000 COLUMN tablespace_name format a10 COLUMN file_name format a45 COLUMN free% format a7 SELECT df.tablespace_name,SUBSTR (df.file_name, 1, 60) file_name, df.bytes/1024/1024/1024 allocated_GB, round(((df.bytes/1024 /1024/1024) – NVL(SUM(dfs.bytes)/1024/1024 /1024, 0)),1) used_GB, round(NVL(SUM (dfs.bytes)/1024/1024/1024, 0),2) free_space_GB FROM dba_data_files df, dba_free_space dfs WHERE df.FILE_ID = dfs.file_id(+) GROUP BY