As far as I know, there is no built-in SQL commands history. Some utilities (TOAD, for example, *maybe* iSQL*Plus (I can't check that one at the moment)) have such a functionality, but I don't know how it is implemented (whether using genuine Oracle system tables or some other way).
There is, however, something that might (or, on the other hand, might not) interest you, and it is called the Oracle Flashback Technology.
---------- issue your queries ------------
-- For a user --
SELECT sql_redo, sql_undo FROM v$logmnr_contents
WHERE USERNAME = 'whoever' ;
--- Occurances for a table ---
SELECT to_char(timestamp,'HH24:MIS'),USERNAME,OPERATION,STATUS, sql_redo
WHERE SEG_NAME = 'table_name';
-- Table hits --
SELECT seg_owner, seg_name, count(*) AS Hits FROM
v$logmnr_contents WHERE seg_name NOT LIKE '%$' GROUP BY
Lookup the documentation on logmining and have fun ... Again, this is just
the DML statements ... If you are using Oracle9i or above and are using
the UNDO tablespace, then you also have the "flashback query" options