Versions Compared

Old Version 3

changes.mady.by.user Sidney Chen

Saved on

compared with

New Version Current

changes.mady.by.user Chichi

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Scroll ignore
scroll-viewporttrue
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-htmltrue
scroll-epubtrue

Open in new tab

About Collectors

Insert excerpt
Collector Method
Collector Method
nameabout

...

Pre-requisites

...

Python 3.8 - 3.11

...

Collector Server Minimum Requirements

Insert excerpt
Collector Method
Collector Method
nameCollectorServerSpec
nopaneltrue

Oracle Database requirements

  • Access toOracle (see section below)

Oracle Access

...

  • Oracle user with read access to following tables

    • dba_hist_active_sess_history

    • dba_hist_snapshot

    • dba_users

    • dba_hist_sqltext

    • dba_mviews

    • dba_views

    • dba_procedures

    • dba_constraints

    • dba_cons_columns

    • dba_tab_columns

    • dba_audit_trail (If you do not have Auditing configured, speak to KADA about it.)

    • dba_tab_privs

    • dba_role_privs

    • dba_roles

    • proxy_users_and_roles

    • dba_synonyms

Check the MAX_STRING_SIZE option in the database , if it is not of type EXTENDED and you are unable to change it, you will need to alter the DDL_SQL used by the extractor and change from 32767 to the maximum supported value in MAX_STRING_SIZE instead. If this is not aligned you will see an ORA-00910: specified length is too long for its datatype will be thrown.

...