select to_char(first_time, ‘RRRRMMDDHH24’), COUNT (CASE WHEN TO_NUMBER(TO_CHAR(FIRST_time, ‘MI’)) 30 THEN 1 ELSE NULL END) COUNT2 FROM V$LOG_HISTORY GROUP BY to_char(first_time, ‘RRRRMMDDHH24’) order by 1 / TO_CHAR(FI COUNT1 COUNT2 ———- ———- ———- 2010020906 3 1 2010020907 3 1 2010020908 3 1 2010020909 3 1 2010020910 3 1 2010020911 3 1 2010020912 3 1 2010020913 3 1…
SQL> select * from sys.pending_trans$ where local_tran_id = ‘26.2.2712168’; no rows selected SQL> select * from sys.pending_sessions$ where local_tran_id = ‘26.2.2712168’; no rows selected SQL> select * from sys.pending_sub_sessions$ where local_tran_id = ‘26.2.2712168’; no rows selected SQL> select * from dba_2pc_neighbors; no rows selected SQL> select * from dba_2pc_pending; no rows selected SQL> commit force…
COL LOCAL_TRAN_ID FORMAT A13 COL IN_OUT FORMAT A6 COL DATABASE FORMAT A25 COL DBUSER_OWNER FORMAT A15 COL INTERFACE FORMAT A3 SELECT LOCAL_TRAN_ID, IN_OUT, DATABASE, DBUSER_OWNER, INTERFACE FROM DBA_2PC_NEIGHBORS / SQL> CONNECT SYS@hq.acme.com AS SYSDBA SQL> @neighbors_script LOCAL_TRAN_ID IN_OUT DATABASE DBUSER_OWNER INT ————- —— ————————- ————— — 1.15.870 out SALES.ACME.COM SYS C
COL LOCAL_TRAN_ID FORMAT A13 COL GLOBAL_TRAN_ID FORMAT A30 COL STATE FORMAT A8 COL MIXED FORMAT A3 COL HOST FORMAT A10 COL COMMIT# FORMAT A10 SELECT LOCAL_TRAN_ID, GLOBAL_TRAN_ID, STATE, MIXED, HOST, COMMIT# FROM DBA_2PC_PENDING /
http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/2471975d4f31c8aa/Default.aspx
-Default order of NAMES. DIRECTORY_PATH is TNSNAMES, OID, HOSTNAME in sqlnet.ora. -EZCONNECT is available after 10g onwards. -Make sure Names.default_domain is set property to avoid any kind of client connectivity issues.
Option: Try each address, in order, until one succeeds ( Failover only). By default failover=true if you have more than one entry in address list. ============================================================================= MEHTA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = NYBOX)(PORT = 1555)) (ADDRESS = (PROTOCOL = TCP)(HOST = FLBOX)(PORT = 1600)) ) (CONNECT_DATA = (SERVICE_NAME =…
-SERVICE_NAMES = INSTANCE_NAME + DB_DOMAIN -GLOBAL DATABASE NAME should be same as SERVICE_NAMES -If system ts is LMT then temporary tablespace is required. -if system ts is lmt then no dmt can be created in db. -When system ts is LMT then undo tbs is also must. -1 tbs can have max 1022 dbfs. -1…
goal: Does DBMS_JOB recompute the NEXT_DATE interval after or before executing the procedure or job? fact: PL/SQL fix: The NEXT_DATE is computed AFTER the job gets executed successfully. The INTERVAL date function is evaluated immediately before a job is executed. If the job completes successfully, the date calculated from INTERVAL becomes the new NEXT_DATE. If…
Read More “Does DBMS_JOB recompute the NEXT_DATE interval after or before” »
Committing Using Only the Transaction ID The following SQL statement commits an in-doubt transaction: COMMIT FORCE ‘transaction_id’; The variable transaction_id is the identifier of the transaction as specified in either the LOCAL_TRAN_ID or GLOBAL_TRAN_ID columns of the DBA_2PC_PENDING data dictionary view. For example, assume that you query DBA_2PC_PENDING and determine that LOCAL_TRAN_ID for a distributed…
Read More “Committing distributed transaction using commit force” »
