You seem to be a little confused. You seem to be switching between references to memory and tablespaces. These are not the same thing. A tablespace holds physical objects such as tables and indexes etc. Views are stored queries in the dictionary. Inline views are generated at runtime as the query is processed. Neither type of view has anythign to do with tablespaces.
If you are concerned about the memeory usage of a query I suggest you check out the v$sesstat view. This provides all the statistical information Oracle has related to a session. The names of the statistics can be displayed in a more readable form using the v$statname view.