Archive for the ‘DBA’ Category

Oracle releases Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86 and Linux x86-64 platforms.

From my previous expriences with script utlrp.sql provided by Oracle, for mass-compilation of invalid objects, I recommend running this script only in STARTUP UPGRADE / MIGRATE mode. Otherwise you may end up with dictionary and or schema incosistencies especially if you use alot of schema objects (45 000+) .
$ORACLE_HOME/rdbms/admin/utlrp.sql

10.2.0.3 has a nasty bug, where one is not able to see what SQL is job actually executing, the following fix will resolve that partially. For parallel slaves the relevant v$session columns are still going to be empty.
5928612 SQL ADDRESS COLUMN IN V$SESSION VIEW FOR JOB IS ZERO
This might be resolved completely in 10.2.0.4, anyone?

Oracle patchset 10.2.0.4

Oracle patchset 10.2.0.4 is now available via metalink for Windows(32bit) and Linux x86(32bit) platforms.
Update 22.05.2008: Now available also for some 64 bit platforms like AIX5L 64.

If you’ve just upgraded from 9i to 10g, and you are using unsupported collection return types in pipelined functions you are no longer able to compile the code due to a more restrictive 10g compiler. Your pipelined functions compiled just fine on 9i. You are unable to compile the functions with the following error message [...]

Microsoft Windows (1.7 GB)
Linux x86 (1.7 GB)
Linux x86-64 (1.8 GB)

I’ve recently came across excelent article/how-to for Oracle 11g RAC na Oracle Enterprise Linux 4(Update 5) a VMware Server 1.0.3. Thank you Frikkie.

Too much log switching is no good for database, you should see numbers not bigger than 6 per hour. Increasing the size of redo log groups is one way to lower log switch frequency, please refer to Oracle documentation on how to lower log switch frequency.
You can use the following query to determine your log [...]

You can determine users idle time using the following query:

List of DBA Views

SELECT * FROM DICT
WHERE TABLE_NAME LIKE 'DBA\_%' ESCAPE '\'

List of Dynamic Performance Views
(these are only synonyms for SYS.GV_$)

SELECT * FROM DICT WHERE TABLE_NAME LIKE 'V$%'

List of Global Dynamic Performance Views used in RAC
(these are only synonyms for SYS.GV_$)

SELECT * FROM DICT WHERE TABLE_NAME LIKE 'GV$%'

Note: The content of V$ and GV$ views [...]

Blogroll

Buy me a Coffee