#What is oracle 10g update#
It's also used to update statistics and provide a heart beat mechanism. ASMB - This ASMB process is used to provide information to and from cluster synchronization services used by ASM to manage the disk resources.Change Tracking Writer (maximum 1) CTWR - CTWR will be useful in RMAN.Memory Monitor Light (maximum 1) MMNL - New background process in Oracle 10g.Memory Monitor (maximum 1) MMON - MMON monitors SGA and performs various manageability related background tasks.It is a new process added to Oracle 10g as part of automatic shared memory management. Memory Manager (maximum 1) MMAN - MMAN dynamically adjust the sizes of the SGA components like DBC, large pool, shared pool and java pool.SGA_TARGET = DB_CACHE_SIZE + SHARED_POOL_SIZE + JAVA_POOL_SIZE + LARGE_POOL_SIZE It doesn't include log buffer, streams pool and the buffer pools for nonstandard block sizes and the non-default ones for KEEP or RECYCLE. It includes buffer cache, shared pool, java pool and large pool. This is called Automatic Shared Memory Management ( ASMM). Introduced new init parameter, sga_target, to change the value of SGA dynamically.Streams pool ( streams_pool_size parameter), useful for datapump activities & streams replication. New 'drop database' statement, will delete the datafiles, redolog files mentioned in control file and will delete SP file also.SQL> ALTER TABLESPACE UNDO_TS RETENTION GUARANTEE In Oracle 10g, undo tablespace can guarantee the retention of unexpired undo extents.If ENDIAN formats are different we have to use RMAN.
#What is oracle 10g windows#
Windows to Linux, Solaris to HP-UX), which has same ENDIAN formats. Ability to transport tablespaces across platforms (e.g.SQL> ALTER TABLESPACE oldname RENAME TO newname
Ability to rename tablespaces (except SYSTEM and SYSAUX), whether permanent or temporary, using the following command:.Ability to UNDROP ( Flashback Drop) a table using a recycle bin.Flashback operations available on row, transaction, table or database level.Automatic Database Diagnostic Monitor ( ADDM).Performance and scalability improvements.Manageability improvements (self-tuning features).ASMB, RBAL, ARBx are the new background processes related to ASM. Grid Control is used for accessing/managing multiple instances. Through any browser we can access data of a database in Oracle Enterprise Manager Database Control. Oracle Enterprise Manager ( OEM) became browser based.