on 10-30-2008 4:25 PM
Hi all,
OSS note 408532 states that brconnect uses DBMS_STATS to gather statistics for Oracle 10g. Is there any way to independently verify this and see the actual database command that brconnect is using?
Our database is at 10.2.0.2 and BRTools is at 7.00 (34).
Dave Frisch
yes you can, before running BRCONNECT, set environement variable BR_TRACE to 15
on Windows:
set BR_TRACE=15
brconnect -c -u / -f stats -t collect
you will see all SQL requests made, including the call for DBMS_STATS.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.