Oracle 10g Release 2 now available for downloadJuly, 6, 2005
The long-awaited GA (general
availability) released of 10gr2 has finally come, and Oracle geeks
across the globe are ecstatic:
have an article on SearchOracle about the general
new features of Oracle 10g, but note that Oracle 10g release 2
has some fun new features to explore.
Nanda, Author of
Privacy Security Auditing: Includes Federal Law Compliance with
HIPAA, Sarbanes-Oxley & The Gramm-Leach-Bliley Act GLB and
respected Oracle expert, has a superb list of Oracle 10g release 2
features on OTN:
favorite 10g r2 new goodies include:
Direct SGA access with Memory Access Mode (MAM)Sounds cool. According to Nanda: - "In Oracle Database
10g Release 2, Oracle Enterprise Manager Grid Control can, under
demanding circumstances, attach directly to the SGA at your
request—and thereby collect data directly from the process state.
This so-called Memory Access Mode enhances your ability to use
Oracle Enterprise Manager effectively even when the instance is
experiencing severe problems. And best of all, this is done
automatically when SQL access is virtually impossible.
Note that the Memory Access mode is not a
replacement for SQL access; it's intended only for emergencies when
SQL access is unavailable. Furthermore, Memory Access mode provides
only that subset of data that is useful for analyzing hung sessions.
(More on that subject in the next installment, on Performance
DML error logging
Error Logging features allows you to capture DML errors (insert,
update, delete). Nanda notes
that the DML logging can changes the behavior of the "all or
nothing" nature of a DML statement, allowing some rows to be updated
while other fail::
Without the error-logging clause, the whole statement would have
failed, with no records rejected. Through this clause, only the
invalid records were rejected; all others were successful.
This is a Godsend to developers
who used to have to code around DML errors with custom routines.
ASM command line
ASM has been well-received by
Oracle DBA experts and the Stripe-and-mirror-everywhere (SAME) had
become the de-facto standard for Oracle datafile-disk mapping.
Dr. Arun Kumar covers ASM in great detail in his latest book "Easy
Oracle Automation" and now
Nanda notes that and it now has a command-line interface:
"This interface, called asmcmd, lets you do a lot of things with
the datafiles stored in ASM diskgroups, which are akin to
filesystems and corresponding files. The tool is based on Perl,
so the latter needs to be in the path. If the path to Perl is
not set properly, you may want to create a soft link to the
directory where Perl exists, or just modify the file asmcmd to
reflect the correct path of the Perl executable."