selectcount(*) Reboot database:
shutdownimmediate;
startup;

–check which users are currently using data
SELECTosuser,a.username,cpu_time/executions/1000000 ±s’,sql_fulltext,machine
fromv$sessions,v$sqlareab
where a.sql_address=b.addressorderbycpu_time/executionsdesc;