cancel
Showing results for 
Search instead for 
Did you mean: 

How verify what database command brconnect is using to gather stats?

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member204746
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Thanks Eric,

Your answer gave me everything I needed to know. Trace Level of 1 was sufficent in this case.

Answers (0)