ITPub博客

select 'select count(*) from  '|| table_name ||' ;' from all_tables where wner='SERVICE';  select t.table_name,t.num_rows from user_tables t

当某个数据库用户在数据库中插入、更新、删除一个表的数据，或者增加一个表的主键时或者表的索引时，常常会出现ora-00054:resource busy and acquire with nowait specified这样的错误。主要是因为有事务正在执行...

查询sql的历史记录select * from v$sqlarea t where t.PARSING_SCHEMA_NAME in ('用户名') order by t.LAST_ACTIVE_TIME descselect * from v$sqlarea t order by t.LAST_ACTIVE_TIME desc查看一段时间内的执行情...

select '"' + area + '"', '"' + pvname + '"', '"' + city + '"', '"' + name + '"', '"' + visitoutscode + '"', '"' + questions + '"', '"' + fname + '"', '"' + pname + '"', scoresfrom dbo.tchanges;

http://www.hellodba.com/index.php?class=doc&lang=cnhttp://www.jiagulun.com/thread-57-1-17.html SET VERIFY OFF  SET FEEDBACK OFF  SET SERVEROUTPUT ON SIZE 1000000   execute ...

set pages 100set head onset lines 300set trims oncol file_name format a45select tablespace_name, file_name, bytes/1024 Kbytes from  dba_temp_files;accept ts_name prompt "Enter TEMPORARY tabl...

select table_name,column_name,endpoint_number,endpoint_valuefrom user_tab_histogramswhere user_tab_histograms.TABLE_NAME='TVEHICLE_EXPORTS'and Column_name='ISVALID'; exec DBMS_STATS.GATHER_TABL...

select b.* from gv$session a,gv$sqlarea b where a.sql_id=b.sql_id where a.sid='499'