Google+ Followers

Pages

Tuesday, August 9, 2011

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



Monday, August 1, 2011

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/