Memory load extremely high
Hello,
When I request SELECT * FROM dev_dwh.ods_ventes o on the table that contains 85 billion of rows, following message ‘The memory load of the system is extremely high. This is likely because of the current result being very large’ displays in about 1,5 billion of extracted rows.
How to do to extract the 85 millions of rows? Is it possible? Should it parameter anything in MYSQL Server? Or perhaps in RAM memory windows server?
Thank you very much for your help.
Best regards,
Christopher
Subject
Views
Written By
Posted
Memory load extremely high
8720
October 24, 2011 07:24AM
3127
October 30, 2011 03:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.