Oracle
« Previous EntriesFAST_START_MTTR_TARGET
Tuesday, June 7th, 2011Durch FAST_START_MTTR_TARGET können Sie festlegen, wie lange das Crash-Recovery maximal dauern soll. Angenommen, Sie setzen FAST_START_MTTR_TARGET auf 180, so bedeutet diese Einstellung, dass die Instanz nach einem Fehler (Stromausfall etc.) nach maximal 180 Sekunden, also 3 Minuten, wieder verfügbar ist. Durch die Einstellung FAST_START_MTTR_TARGET wird also bestimmt, wann Dirty Blocks vom Cache in die Datendateien [...]
Date und Time Formate
Wednesday, February 23rd, 2011CC Century SCC Century BC prefixed with – YYYY Year 1956 SYYY Year BC prefixed with – IYYY ISO Year 1956 YY Year 56 RR Year 56 rollover for Y2K compatibility * RRRR Year rollover (accepts 2 digits, returns 4) * YEAR Year spelled out SYEAR Year spelled out BC prefixed with – BC BC/AD [...]
Ergebnisse eines select statements im file speichern
Wednesday, February 23rd, 2011spool d:\temp\abc.txt; Das file als abc.txt im Verzeichnis tmp öffnen select to_char(Datum, ‘YYYYMMDD’),Eroeffnung, hoechst,tiefst,schluss, volumen from WPKursdaten where wp_id =’24163′; spool off; file schließen
Teilstrings in varchar2 Feld ändern
Tuesday, February 15th, 2011Update tablename set Tabellenname = replace (Tabellenname,’zu ersetzender String’, ‘Ersatzstring’);
alter table column examples
Tuesday, February 15th, 2011ALTER TABLE customer MODIFY ( cust_name varchar2(100) not null, cust_hair_color varchar2(20) ) ; dynamic PL/SQL BEGIN SQL_STRING := ‘ALTER TABLE ‘||:TABLE_NAME||’ MODIFY ‘||:COLUMN_NAME||’ VARCHAR2(100)’; . . . END;
ORA-12537: TNS: connection closed error
Monday, August 30th, 2010The ORA-12537 is an information message and means that the connection has been closed. This can be caused by a number of reasons: 1. Database is shut down (maybe for nightly backup), but connection to database was kept by client. 2. A time-out occurred on the client-connection. 3. When firewall closes idle connections. 3. A [...]
« Previous Entries