The SQL that Oracle often uses

Select  *  fromTabs--All tables under the current userSelect *    fromDual--Pseudo TableSelect *  from(Select *  fromFduserOrder  byDbms_random.value)whereRowNum=1;--randomly querying a single piece of data

ALTER USER TMFC account UNLOCK               --  unlocks the user  when the user's password verification fails 10 consecutive times after the   accounts are locked

 alter  system set  Sec_case_ Sensitive_logon=  false  set Oracle case insensitive  

   -- View the name of the tablespace and the file to which it belongs   Select file_id file_name ,    round (Bytes/(1024x768*1024x768),0) total_space     from dba_data_files    Order  by Tablespace_name;

--View Table SpacesSELECT UPPER(f.tablespace_name) "tablespace name", D.TOT_GROOTTE_MB "table space size (M)", D.TOT_GROOTTE_MB-f.total_bytes "used Space (M)", To_char (ROUND((D.TOT_GROOTTE_MB-F.total_bytes)/D.tot_grootte_mb*  -,2),'990.99'"Use ratio", f.total_bytes "free Space (M)", F.max_bytes "Max Block (m)" from(SELECTTablespace_name,ROUND(SUM(BYTES)/(1024x768 * 1024x768),2) Total_bytes,ROUND(MAX(BYTES)/(1024x768 * 1024x768),2) Max_bytes fromSYS. Dba_free_spaceGROUP  bytablespace_name) F, (SELECTDD. Tablespace_name,ROUND(SUM(DD. BYTES)/(1024x768 * 1024x768),2) TOT_GROOTTE_MB fromSYS. Dba_data_files DDGROUP  byDD. Tablespace_name) DWHERED.tablespace_name=F.tablespace_nameORDER  by 4 DESC;

ALTER Tablespace Tmfc_tbs   ADD'D:\oradata\mesdb\TMFC_29.DBF' SIZE 4000M   --  Increase table's data file  extension table space