pdb_thread_filter

(Oracle RAC only) Filters all activity on an Oracle instance redo log thread or threads during replication, and displays a list of threads being filtered.

Syntax

pdb_thread_filter [
   add, thread_id 
 | 
   remove, { thread_id | all }
]

Parameters

  • add – adds the specified thread ID to the list of threads being filtered.
  • remove – removes the specified thread ID or all thread IDs from the list of threads being filtered.
  • thread_id – is the thread ID to add to or remove from the list of threads being filtered.
  • all – removes all threads from the list of threads being filtered.

Examples

  • Example 1 – 
    pdb_thread_filter add, 1

    Filters activity on thread 1.

  • Example 2 – 
    pdb_thread_filter remove, 1

    Removes thread 1 from the list of threads being filtered.

  • Example 3 – 
    pdb_thread_filter remove, all

    Removes all threads from the list of threads being filtered.

  • Example 4 – 
    pdb_thread_filter

    Displays a list of threads being filtered.

Usage

  • Incorrect use of pdb_thread_filter may result in loss of data.
  • Use pdb_thread_filter only under the direction of Sybase Technical Support when a thread being filtered may not be running.