Found 565 bookmarks
Newest
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
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$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
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
Canonical Kernel Livepatch Service now available for Ubuntu 14.04 LTS! | Ubuntu Insights
Canonical Kernel Livepatch Service now available for Ubuntu 14.04 LTS! | Ubuntu Insights
We are pleased to announce that we have extended our Canonical Kernel Livepatch Service to users running Ubuntu 14.04 LTS! The Canonical Kernel Livepatch Service enables runtime correction of critical security vulnerabilities in the kernel without the need to reboot. It is the best way to ensure that machines are safe at the kernel level, […]
·insights.ubuntu.com·
Canonical Kernel Livepatch Service now available for Ubuntu 14.04 LTS! | Ubuntu Insights
How to Compress and Extract Files Using the tar Command on Linux
How to Compress and Extract Files Using the tar Command on Linux
The tar command on Linux is often used to create .tar.gz or .tgz archive files, also called “tarballs.” This command has a large number of options, but you just need to remember a few letters to quickly create archives with tar. The tar command can extract the resulting archives, too.
·www.howtogeek.com·
How to Compress and Extract Files Using the tar Command on Linux