Background Processes in the Exadata Cell Environment on database server: The background processes for the database and Oracle ASM instance for an Exadata Cell environment are the same as other environments, except for the following background process: – diskmon Process – The diskmon process is a fundamental component of Exadata Cell, and is responsible for […]
set serveroutput on declare cursor c1 is select version from v$instance; cursor c2 is select host_name , instance_name , to_char(sysdate, ‘HH24:MI:SS DD-MON-YY’) currtime , to_char(startup_time, ‘HH24:MI:SS DD-MON-YY’) starttime from v$instance; cursor c4 is select * from (SELECT count(*) cnt, substr(event,1,50) event FROM v$session_wait WHERE wait_time = 0 AND event […]
Po vyrieseni archiver stuck stavu databaze moze trochu trvat pokial sa preberie a zisti ze archive_dest je volna… archivacia a skratenie tohto cakania sa da vynutit pomocou SQL> alter system archive log all;
kolega dnes nasiel takuto vychytavku.. znacne lepsie ako z cron-u forcovat alter system switch logfile; ARCHIVE_LAG_TARGET Property Description Parameter type Integer Default value 0 (disabled) Modifiable ALTER SYSTEM Range of values 0 or any integer in [60, 7200] Basic No Oracle RAC Multiple instances should use the same value. ARCHIVE_LAG_TARGET limits the amount of data […]
alter system set events ‘sql_trace [sql:60x3man71byuz] level 12’; alebo SQL> — Setting Oracle PID to trace and verify by crossing the result of the system pid SQL> oradebug setorapid 25 Oracle pid: 25, Unix process pid: 4850, image: oracle@oel (TNS V1-V3) SQL> — nolimit to tracefile SQL> oradebug unlimit Statement processed. SQL> — tracing SQL_Optimizer […]
$ORACLE_HOME/bin/createinstance –instanceName meno -groupName meno_grupy
x$bh Buffer Hash x$kcbsw kernel cache, buffer statistics why Note:34405.1 (select kcbwhdes, why0+why1+why2 “Gets”, “OTHER_WAIT” from x$kcbsw s, x$kcbwh w where s.indx=w.indx and s.”OTHER_WAIT”>0 order by 3), Ref1 (“statistics about the way these [x$kcbwh] functions have been used”) x$k2gte Kernel 2-phase commit, Global Transaction Entry Mark Bobak’s query (originally in Metalink forum thread 524821.994, where […]
Uzitocne v napr. skriptoch COLUMN Specifies display attributes for a given column, such as, column heading text, column heading alignment, data format, column data wrapping. Also lists the current display attributes for a single column or all columns. Syntax: COLUMN [ {column_name | expr} ] option COL Lists current display attributes for all column_name currently […]
Ak nahodou bude treba exportovat/importovat do Vault-enablovanej databaze autorizuje a deautorizuje sa to procedurami DVSYS.DBMS_MACADM.AUTHORIZE_DATAPUMP_USER DVSYS.DBMS_MACADM.UNAUTHORIZE_DATAPUMP_USER samozrejme, ako dvown user..
Uzitocne ak zdedite enviroment v ktorom nic neviete najst v$rman_configuration v$rman_status v$rman_output v$rman_backup_subjob_details v$rman_backup_job_details v$rman_backup_type