OEM table browse diplay limit

[yxez]

Hi Friends,

I am using OEM to browse/display tables for a clearer view of rows in grid and eventually save it to .csv. I am usually prompted when I browse an entire table with rows >2,000 if I continue to browse all or not. But lately when I
use OEM in another server, It did not prompt me the >2,000 causing to display 100,000+ rows which casuse perfomance problem on the server.

How do I put the prompt-browsing limit for OEM Please.


Thanks a lot

[davey23uk]

you'd think after all the posts you've made and the mount of times you have been told - what is the version you are using?

[yxez]

ah yes....my apologies, im using 10gr2 anyway, I solved my problem
when I analyzed the table
Why not Oracle analyzed in dafault all the tables

Thanks