There are various TMemoryDataSet components available. You could search the popular Delphi component sites to find the one that suits your requirements.
Performance depends on a lot of factors. The size of the table, the speed of your PC, Network, and Oracle Server, and of course the application logic that needs to query this table.
------------------
Marco Kalter
Allround Automations