Oracle dictionary statistics cannot be collected

[Former Member]

hello Experts

i cannot Creating Oracle system statistics using BRCONNECT .My Update optimizer statistics operation in db14 hangs at (BR1311I Starting collection of Oracle dictionary statistics.) at the end keeps running indefinitely . please help me in how to overcome this situation

BR0280I BRCONNECT thread 1 time stamp: 2016-01-22 12.00.22

BR0850I 268 of 268 objects processed - 52.060 of 52.060 units done

BR0204I Percentage done: 100.00%, estimated end time: 12:00

BR0001I **************************************************

BR0280I BRCONNECT time stamp: 2016-01-22 12.00.23

BR0848I Thread 1 finished with return code 0

BR0280I BRCONNECT time stamp: 2016-01-22 12.00.23

BR0879I Statistics checked for 55232 tables

BR0878I Number of tables selected to collect statistics after check: 267

BR0880I Statistics collected for 267/0 tables/indexes

BR1490I Statistics collected for 3 individual partition of 2 partitioned table

BR0280I BRCONNECT time stamp: 2016-01-22 12.00.24

BR1311I Starting collection of Oracle dictionary statistics...

BR0285I This action can take several seconds/minutes - be patient...

Regards

Rahul

[Former Member]

Hi Rahul,

Update statistics usually takes sometime, you need to wait until it completes or gives any error.

Trying to run the statistics using below command...

$ brconnect -u / -c -f stats -t all

If nothing works try upgrading BrTools to latest version and try.

Regards,

Prithviraj.

[Former Member]

hi prithviraj

i have tried through this command as well but it hangs  at the below step .

its been running for 10 days now

BR1311I Starting collection of Oracle dictionary statistics...

BR0285I This action can take several seconds/minutes - be patient.......

regards

Rahul

[Former Member]

Hi,

Please check alert/trace/log files for more information.

Check if there is any wait sessions v$session_wait, .lock file created.

Regards,

Prithviraj.