常用的sql语句具体有哪些，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。

1. /* 得到trace文件路径和名称 */

SELECTd.VALUE||'/'||LOWER(RTRIM(i.INSTANCE,CHR(0)))||'_ora_'||p.spid||'.trc'trace_file_nameFROM(SELECTp.spidFROMv$mystatm,v$sessions,v$processpWHEREm.statistic#=1ANDs.SID=m.SIDANDp.addr=s.paddr)p,(SELECTt.INSTANCEFROMv$threadt,v$parametervWHEREv.NAME='thread'AND(v.VALUE=0ORt.thread#=TO_NUMBER(v.VALUE)))i,(SELECTVALUEFROMv$parameterWHERENAME='user_dump_dest')d

2./* 显示产生锁定的sql语句 */

select/*+NO_MERGE(a)NO_MERGE(b)NO_MERGE(c)*/a.username,a.machine,a.sid,a.serial#,a.last_call_et"Seconds",b.id1,c.sql_text"SQL"fromv$sessiona,v$lockb,v$sqltextcwherea.usernameisnotnullanda.lockwait=b.kaddrandc.hash_value=a.sql_hash_value;

3./* 查看oracle隐藏参数 */

selectname,value,decode(isdefault,'TRUE','Y','N')as"Default",decode(ISEM,'TRUE','Y','N')asSesMod,decode(ISYM,'IMMEDIATE','I','DEFERRED','D','FALSE','N')asSysMod,decode(IMOD,'MODIFIED','U','SYS_MODIFIED','S','N')asModified,decode(IADJ,'TRUE','Y','N')asAdjusted,descriptionfrom(--GV$SYSTEM_PARAMETERselectx.inst_idasinstance,x.indx+1,ksppinmasname,ksppity,ksppstvlasvalue,ksppstdfasisdefault,decode(bitand(ksppiflg/256,1),1,'TRUE','FALSE')asISEM,decode(bitand(ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED','FALSE')asISYM,decode(bitand(ksppstvf,7),1,'MODIFIED','FALSE')asIMOD,decode(bitand(ksppstvf,2),2,'TRUE','FALSE')asIADJ,ksppdescasdescriptionfromx$ksppix,x$ksppsvywherex.indx=y.indxandsubstr(ksppinm,1,1)='_'andx.inst_id=USERENV('Instance'))orderbyname;

4./* 根据系统中oracle的pid来查看sql */

select/*+ORDERED*/sql_textfromv$sqltextawhere(a.hash_value,a.address)IN(selectdecode(sql_hash_value,0,prev_hash_value,sql_hash_value),decode(sql_hash_value,0,prev_sql_addr,sql_address)fromv$sessionbwhereb.paddr=(selectaddrfromv$processcwherec.spid='&pid'))orderbypieceASC;

看完上述内容，你们掌握常用的sql语句具体有哪些的方法了吗？如果还想学到更多技能或想了解更多相关内容，欢迎关注亿速云行业资讯频道，感谢各位的阅读！