utworzone przez | lip 15, 2009 | Oracle
viewdescription dba_db_linkslinksv$dba_registryinstalled componentsv$transportable_platformbig-endian,little-endian bytes orientationnls_database_parametersencodingv$pwfile_usersusers from password file
utworzone przez | maj 11, 2009 | Oracle
query order:FROM/WHEREadd ROWNUM to every row from FROM/WHERESELECTGROUP BYHAVINGORDER BY
utworzone przez | maj 3, 2009 | Oracle
running mode:STARTUP NOMOUNTstartup instance and occupy memoryread pfile in order:- spfile$ORACLE_SID.ora or- spfile.ora or- init$ORACLE_SID.ora(for winshit it is necessary run service which open ORACLE.EXE [instance_name] and only one process unlike many processes at...
utworzone przez | kwi 30, 2009 | Oracle
download opatchdownload patchunpackshutdown instanceread README filechange directory to unpacked archiveopatch applyrun Post Installation Instructionscheck patches allready install:opatch lsinventoryopatch lsinventory -detailcheck patch:opatch query -all...
utworzone przez | mar 17, 2009 | Oracle
FLASHBACK DEPEND ON UNDO DATA-conditions:UNDO_MANAGEMENT=AUTOUNDO_RETENTION=900 #(in seconds 900 equal 15min, if value is extended UNDO tablespace will be increased also)only for DML because FLASHBACK use data directory, but DDL cause ORA-01466only for DELETE because...
utworzone przez | mar 3, 2009 | Oracle
exec DBMS_STATS.GATHER_SCHEMA_STATS('[username]’, cascade=>TRUE);exec #dla tabeli wraz z indeksami DBMS_STATS.GATHER_TABLE_STATS('[username’,'[table_name]’,cascade=>TRUE); #dla całego schematu wraz z indeksamiTIMED_STATISTICS = TRUESELECT...
