difference between core dba and apps dba

Oracle Apps DBA Activities:

---------------------------

He is mainly responsible for handling the Oracle Applications, which is exclusively designed by Oracle, in terms of Installing Oracle Application software  either on single node or multi node, Upgrading Oracle Applications from lower version to latest versions, Applying patches suggested by Oracle Support, Cloning Oracle Application Instances, and Lot more Oracle DBA Activities.

Oracle Core DBA Activities:

---------------------------

He is only the contact of person for database related issues, and he will no more responsible for Applications. He always responsible for Installation of Oracle software, Up gradation, Cloning, and other activities RMAN, Standby, RAC, etc..

Resize Datafile to Optimal Size

SQL> Define BLKSIZE=

SELECT /*+rule*/ 'ALTER DATABASE DATAFILE '''||FILE_NAME||''' RESIZE '||CEIL( (NVL(HWM,1)*&&BLKSIZE)/1024/1024 )||'M;',

CEIL( (NVL(HWM,1)*&&BLKSIZE)/1024/1024 ) SMALLEST,

CEIL( BLOCKS*&&BLKSIZE/1024/1024) CURRSIZE,

CEIL( BLOCKS*&&BLKSIZE/1024/1024) -

CEIL( (NVL(HWM,1)*&&BLKSIZE)/1024/1024 ) SAVINGS

FROM DBA_DATA_FILES A,

( SELECT FILE_ID, MAX(BLOCK_ID+BLOCKS-1) HWM

FROM DBA_EXTENTS

GROUP BY FILE_ID ) B

WHERE A.FILE_ID = B.FILE_ID(+)

OUTPUT 'ALTERDATABASEDATAFILE'''||FILE_NAME||'''RESIZE'||CEIL((NVL(HWM,1)*8192)/1024/1024)||'M;' SMALLEST CURRSIZE SAVINGS ALTER DATABASE DATAFILE 'D:\ORACLCE\APP\ADNAN\ORADATA\ORCL\SYSTEM01.DBF' RESIZE 684M; 684 690 6 ALTER DATABASE DATAFILE 'D:\ORACLCE\APP\ADNAN\ORADATA\ORCL\SYSAUX01.DBF' RESIZE 466M; 466 490 24 ALTER DATABASE DATAFILE 'D:\ORACLCE\APP\ADNAN\ORADATA\ORCL\UNDOTBS01.DBF' RESIZE 89M; 89 90 1 ALTER DATABASE DATAFILE 'D:\ORACLCE\APP\ADNAN\ORADATA\ORCL\USERS01.DBF' RESIZE 5M; 5 5 0 ALTER DATABASE DATAFILE 'D:\ORACLCE\APP\ADNAN\ORADATA\ORCL\EXAMPLE01.DBF' RESIZE 82M; 82 100 18

SQL Server usefull links

http://www.wowebook.com/book/microsoft-sql-server-2008-administration-for-oracle-dbas/


http://www.wowebook.com/book/pro-sql-server-2008-policy-based-management/


http://www.wowebook.com/book/pro-sql-server-2008-mirroring/


http://www.wowebook.com/book/microsoft-sql-server-2008-r2-administration-cookbook/


http://www.wowebook.com/book/sql-server-2008-administration/


http://www.wowebook.com/book/microsoft-sql-server-2008-management-and-administration/


http://www.wowebook.com/book/hands-on-microsoft-sql-server-2008-integration-services-2nd-edition/


http://www.wowebook.com/book/microsoft-sql-server-2008-high-availability/




http://www.wowebook.com/book/sql-server-2008-administration-in-action/


http://www.wowebook.com/book/microsoft-sql-server-2008-r2-unleashed/