-
Oracle datapump stuff / Links
Datapump 101 links: http://www.oracle-base.com/articles/10g/OracleDataPump10g.php http://www.orafaq.com/wiki/Datapump relevant domain names
-
Size of Schema in Oracle
SQL Script to show the size of each schema in an Oracle database: SELECT OWNER,SUM(BYTES/1024/1024) “SIZE OF SCHEMA(MEGABYTES)” FROM DBA_EXTENTS GROUP BY OWNER ORDER BY SUM(BYTES/1024/1024) DESC Check links . web design history
-
Display sql being run by active Oracle sessions
Display sql being run by active Oracle sessions select sesion.sid, sql_text from v$sqltext sqltext, v$session sesion where sesion.sql_hash_value = sqltext.hash_value and sesion.sql_address = sqltext.address and sesion.username is not null order by sqltext.piece
-
I/O being performed by active SQL statements in Oracle
I/O being performed by active SQL statements in Oracle select sess_io.sid, sess_io.block_gets, sess_io.consistent_gets, sess_io.physical_reads, sess_io.block_changes, sess_io.consistent_changes from v$sess_io sess_io, v$session sesion where sesion.sid = sess_io.sid and sesion.username is not null whois domain name .
-
Listing active SQL being run in current Oracle session.
Listing active SQL being run in current Oracle session: select sesion.sid, sesion.username, optimizer_mode, hash_value, address, cpu_time, elapsed_time, sql_text from v$sqlarea sqlarea, v$session sesion where sesion.sql_hash_value = sqlarea.hash_value and sesion.sql_address = sqlarea.address and sesion.username is not null