How to get User sql_id, text in Oracle Database

  SELECT sql_id, sql_text FROM v$sql WHERE parsing_user_id = (SELECT user_id FROM all_users WHERE username = '&user');