Found 27 bookmarks
Custom sorting
How to see lock on table and query? | Oracle Community
How to see lock on table and query? | Oracle Community
select (select username || ' - ' || osuser from v$session where sid=a.sid) blocker, a.sid || ', ' || (select serial# from v$session where sid=a.sid) sid_serial, ' is blocking ', (select username || ' - ' || osuser from v$session where sid=b.sid) blockee, b.sid || ', ' || (select serial# from v$session where sid=b.sid) sid_serial from v$lock a, v$lock b where a.block = 1 and a.id1 = b.id1 and a.id2 = b.id2;
·community.oracle.com·
How to see lock on table and query? | Oracle Community
V$SQL
V$SQL
Esempio: SELECT EXECUTIONS, ROUND(ELAPSED_TIME/EXECUTIONS/1000000, 3) SEC, MODULE, PARSING_SCHEMA_NAME, SQL_TEXT FROM V$SQL ORDER BY ELAPSED_TIME/EXECUTIONS DESC
·docs.oracle.com·
V$SQL
255 columns | Oracle Scratchpad
255 columns | Oracle Scratchpad
You all know that having more than 255 columns in a table is a Bad Thing ™ – and surprisingly you don’t even have to get to 255 to hit the first bad thing about wide tables. If yo…
·jonathanlewis.wordpress.com·
255 columns | Oracle Scratchpad
V$SQLSTATS
V$SQLSTATS
Simile a V$SQL ma più indicata per analizzare le prestazioni delle query, anche non più in cache
·docs.oracle.com·
V$SQLSTATS