How to pin the table into memory
I am beginner to Oracle DBA activity, Please help me how to pin the table into memory? Actually i am working for the BI Dashbroad report project. Our Dashborad is not fatching the data fastly from the database. It is taking time to populate the data on dashbroad(60 Sec).I created index on that table. still i am having the slowness.So let me know the step or command to pin the table.
Thanks in Advance.