SCA 命令行选项

Introduction:
    SCA is the program used to do SQL life-cycle inspection and simulation from Oracle to MogDB.
    There are 4 types of workers:
        1. [I] Compatible inspection about objects and SQLs
        2. [S] SQL performance simulator
        3. [C] Oracle data collector
        4. [M] SQL Compatible with MySQL general/slow-log

Options:
                          --[ Overall ]--
    -h, --help            : Show current help message
    -v, --version         : Show current server version
    -d, --data            : Unzipped data directory for analyzer, or dest location for collection
    -D, --data-id         : Use data with data id existed in the repository
    -t, --target-db       : Target database for all type of running
    -T, --type            : Running Type:  I = Inspection, and automatic building target database, this is default
                          :                S = Simulation, like Oracle SPA, use existing target database
                          :               IO = Inspection Only, use existing target database
                          :               IS = Inspection & Simulation, use existing target database
                          :                C = Run as agent, for data collection
                          :                M = MySQL SQL Inspection
    -w, --workers         : Parallel workers in each tasks, default: 10
    -x, --debug           : Enable debug mode
    -H, --host            : Server host address or name, default: 127.0.0.1
    -P, --port            : Database server port, default: 5432
    -F, --force           : Force mode, drop old objects before create it
                          : In repository initialization, means drop old repository if exists
    -l, --logfile         : Write output to both logfile (without progress-bar) and screen (with progress-bar)
    -L, --log-only        : Write output to only logfile (without progress-bar)
    -r, --report          : Final report file location, default in data directory with name 'report'
    -R, --rewrite         : PLSQL rewrite scripts location, default in data directory with name 'rewrite'
        --slow-log        : MySQL slow-log for SQL Inspection
        --general-log     : MySQL general-log for SQL Inspection
        --sql-csv         : SQL file in csv format for SQL Inspection
        --sql-transformer : Regular rules for SQL transformation (for internal use)
                          : Format: [{"name": "xxx"
                          :           "source": "xxx",
                          :           "target": "xxx",
                          :           "comment": "xxx"}, ...]
                          --[ Repository ]--
    -i, --init            : Initial repository, server connection information needed
    -U, --suser           : [Init] Super user used to login database server, default: mogdb
    -E, --spassword       : [Init] Password for super user, default: mogdb
    -n, --database        : Repository database, default: sca_db
    -u, --user            : Repository user, default: sca_repo
    -e, --password        : Repository password, default: SCA@password
                          --[ Collection ]--
    -C, --catagory        : Collection catagory: A = all, M = object metadata, Q = sql data, default is A
    -q, --sql-days        : How many days for session sql data, default: 7
    -Q, --sql-interval    : SQL collection interval in seconds, default: 600
    -U, --suser           : Oracle user used for data colletion, default: sys
    -E, --spassword       : Password for Oracle login user, default: oracle
    -s, --schema-include  : Users/Schemas included in data collection, default: ''
    -S, --schema-exclude  : Users/Schemas excluded in data collection
                          : Default: SYS,SYSTEM,OUTLN,QS_ES,QS_WS,QS_OS,QS_CBADM,QS_CB,SH,HR,QS,QS_CS,ORACLE_OCM,TSMSYS,DIP,PM,OE,DBSNMP,APPQOSSYS,WMSYS,EXFSYS,CTXSYS,ANONYMOUS,XDB,XS$NULL,ORDDATA,SI_INFORMTN_SCHEMA,ORDPLUGINS,ORDSYS,MDSYS,OLAPSYS,MDDATA,SPATIAL_WFS_ADMIN_USR,SPATIAL_CSW_ADMIN_USR,SYSMAN,MGMT_VIEW,APEX_030200,APEX_040200,FLOWS_FILES,APEX_PUBLIC_USER,OWBSYS,OWBSYS_AUDIT,SCOTT,UNKNOWN,PUBLIC,ODM,ODM_MTR,WKSYS,WKPROXY,DMSYS,IX,AQ$_ORDERS_QUEUETABLE_V
    -m, --enable-monitor  : Starting monitor process in backgroud, Valid values: 1/on/true/t = ENABLE, 0/off/false/f = DISABLE, default: on

Usage:
    1. Init repository and analyze data (used for first running)
       ./sca_linux_x86_64 -i -H <host> -P <port> -U <super-user> -E <super-password> -d <unzipped data directory>
    2. Just analyze data
       ./sca_linux_x86_64 -d <unzipped data directory>
    3. Just Init repository (just need ran once for a repository database)
       ./sca_linux_x86_64 -i -H <host> -P <port> -U <super-user> -E <super-password>
    4. Just do SQL performance simulator (repository database is ready)
       ./sca_linux_x86_64 -T S -d <unzipped data directory>
    5. Do Data collection as agent for test (repository database is not needed)
       # Notice: "-q 0.001 -Q 60" means gather Session SQL only once
       #         "-m off" means do not monitor system status (CPU Idle and Disk Free)
       ./sca_linux_x86_64 -T C -s SCOTT -t '<target-db>' -H <host> -P <port> -U <oracle-user> -E <oracle-password> -q 0.001 -Q 60 -m off
    6. Do Data collection as agent for regular use (repository database is not needed)
       ./sca_linux_x86_64 -T C -s SCOTT -t '<target-db>' -H <host> -P <port> -U <oracle-user> -E <oracle-password>
    7. SQL compatiable analysis for MySQL using slow-log file (repository database is ready)
       ./sca_linux_x86_64 -T M -t <target-db> -H <host> -P <port> -d <report-directory> --slow-log=<slow-log-file>

hongyedba@localhost ~ % ./sca_linux_x86_64 -v
SCA version: 4.1.0