Metalink (useful notes)

--User managed backup
Bug 8750832 : ORA-01113 ERROR TEXT SHOULD SUGGEST DATABASE END BACKUP IF NO FILES RESTORED
--SGA
SYSRESV Utility [ID 123322.1]
oracle@rac1:~> sysresv -l rac1 +ASM1

IPC Resources for ORACLE_SID "rac1" :
Shared Memory:
ID        KEY
16220173    0x5ce9e358
Semaphores:
ID        KEY
393217      0x53b0ad4c
Oracle Instance alive for sid "rac1"

IPC Resources for ORACLE_SID "+ASM1" :
Shared Memory:
ID        KEY
163844      0x00fa5a34
Semaphores:
ID        KEY
98304       0x57aff660
Oracle Instance alive for sid "+ASM1"
 

oracle@rac1:~> sysresv -i 16318477

IPC Resources for ORACLE_SID "rac1" :
Shared Memory:
ID        KEY
16318477    0x5ce9e358
Semaphores:
ID        KEY
1671169     0x53b0ad4c
Oracle Instance alive for sid "rac1"
SYSRESV-005: Warning
    Instance maybe alive - aborting remove for sid "rac1"
 --TNS

(A) Undocumented or Lesser Known SQL*Net/Net8/Net8i Features & Parameters [ID 39357.1]
--Extproc
How To Run An External Procedure Call As Non-Oracle User [ID 1263148.1]  
--NLS
The Priority of NLS Parameters Explained (Where To Define NLS Parameters) [ID 241047.1]
if NLS_LANG is not set then NLS_DATE_FORMAT, etc is IGNORED.
-PL/SQL
How to: Determine if a Package that is About to be Compiled is Being Used Currently [ID 1054939.6]
-Character set conversion
CSSCAN and CSALTER To Be Desupported after DB 11.2. [ID 1418321.1]
-Shutdown immediate
Database shutdown immediate Hangs: Startup can also hang [ID 1194229.1] 
--Flashback query
 Flashback Query Raises Errors Ora-08180 and Ora-01555 [ID 1100993.1]

Комментариев нет:

Отправить комментарий

Update BLOB

set define off DECLARE    vb1 CLOB := 'long text';    vb2 CLOB :=                 'long text';    vb3 CLOB :=              ...