Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE performance Issue

user5388961Sep 10 2013 — edited Oct 3 2013

Hi Guys,

It would be very grateful if you help me with the below issue.

I am running a simple query in OBIEe, which takes very long (keep on running) where the same backend query if i run in SQL, it takes 10 mins to get the result. In Sql it is expected as the data is huge. But why OBIEE is taking such time.

What are the options we can do for the query to increase the performance.

Regards,

Chandu

Comments

What is appearing in the logs of both servers in regards to the connection failure?

3720642

As shown on syslog:

[ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'replica@belem.cidades.gov.br:3306 - retry-time: 60  retries: 1040, Error_code: MY-001129

The last error code given, after a stop slave and some changes to the master (file and log_pos), was Error_code: MY-002061, the rest of the line was the same.

Again, I have no idea what these errors actually are, nor why they went away as soon as I connected manually to the mysql console with the replication user.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details