CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_ASYNCRPC_PUSH
Version 11.1
 
General Information
Source {ORACLE_HOME}/rdbms/admin/prvtarpp.plb
Dependencies
DBMS_DEFER DBMS_REPCAT_SNA_UTL
DBMS_DEFER_QUERY_UTL DBMS_REPCAT_UTL
DBMS_DEFER_REPCAT DBMS_REPCAT_UTL3
DBMS_DEFER_SYS DBMS_SYSTEM
DBMS_DEFER_SYS_PART1 DBMS_SYS_ERROR
DBMS_LOCK DEF$_DESTINATION
DBMS_OFFLINE_RGT DEFTRANDEST
DBMS_REPCAT_DECL REPCAT$_EXTENSION
Object Privileges execute on dbms_asyncrpc_push
GRANT execute on dbms_asyncrpc_push TO uwclass;
 
CHECK_DATABASE_CAPABILITY
Undocumented dbms_asyncrpc_push.check_database_capability(
nodename   VARCHAR2,
userid     BINARY_INTEGER,
capability BINARY_INTEGER)
RETURN BOOLEAN
TBD
 
ERROR_CALL_POSITION
Undocumented dbms_asyncrpc_push.error_call_position(
nodename  IN  VARCHAR2,
userid    IN  BINARY_INTEGER,
position  OUT BINARY_INTEGER)
TBD
 
GET_CLOCK_TIME
Get current time on system clock dbms_asyncrpc_push.get_clock_time RETURN NUMBER;
SELECT dbms_asyncrpc_push.get_clock_time FROM dual;

SELECT dbms_utility.get_time FROM dual;
 
GET_SCN
Returns current system change dbms_asyncrpc_push.get_scn RETURN NUMBER;
SELECT dbms_asyncrpc_push.get_scn FROM dual;

SELECT current_scn FROM v$database;
 
PROPAGATE_PARALLEL

Undocumented
dbms_asyncrpc_push.propagate_parallel(
canon_queue          IN VARCHAR2,
userid               IN BINARY_INTEGER,
stop_on_error        IN BOOLEAN,
new_txn_count        IN BINARY_INTEGER,
startup_seconds      IN BINARY_INTEGER,
execution_seconds    IN BINARY_INTEGER,
delay_seconds        IN BINARY_INTEGER,
num_threads          IN BINARY_INTEGER,
heap_size            IN BINARY_INTEGER,
write_trace          IN BOOLEAN,
delivery_order_limit IN NUMBER,
catchup              IN RAW)
RETURN BINARY_INTEGER;
TBD
 
PROPAGATE_SERIAL
Undocumented dbms_asyncrpc_push.propagate_serial(
queue             IN VARCHAR2,
userid            IN BINARY INTEGER,
stop_on_error     IN BOOLEAN,
new_txn_count     IN BINARY INTEGER,
execution_seconds IN BINARY INTEGER,
delay_seconds     IN BINARY INTEGER,
txn_batch_size    IN BINARY_INTEGER)
TBD
 
PURGE_PARALLEL
Undocumented dbms_asyncrpc_push.purge_paralle(
method            IN     BINARY_INTEGER,
rollback_segment  IN     VARCHAR2,
execution_seconds IN OUT BINARY_INTEGER,
delay_seconds     IN     BINARY_INTEGER,
write_trace       IN     BOOLEAN,
transaction_count IN OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
 
PUSH_PENDING_CALLS
Undocumented dbms_asyncrpc_push.push_pending_calls(
query_type  IN BINARY_INTEGER,
nodename    IN VARCHAR2,
userid      IN BINARY_INTEGER,
buffer_size IN BINARY_INTEGER,
tid         IN VARCHAR2,
call_type   IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
TBD
 
STAMP_QUEUE_BATCH
Undocumented dbms_asyncrpc_push.stamp_queue_batch(scn_limit OUT NUMBER);
set serveroutput on

DECLARE
 n NUMBER;
BEGIN
  dbms_asyncrpc_push.stamp_queue_batch(n);
  dbms_output.put_line(n);
END;
/
 
UPDATE_PURGE_STATISTICS
Undocumented dbms_asyncrpc_push.update_purge_statistics(
txnspurged IN BINARY_INTEGER)
TBD
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [120 users online]    © 2010 psoug.org