select sesion.sid, sesion.username, optimizer_mode, hash_value, address, cpu_time, elapsed_time, sql_text from v$sqlarea...
Read more »
Posts Tagged ‘ sql ’
10GbE
asm
bash
benchmark
binary
bss
compiler
core
corruption
cp
disks
enomem
exec
filer
flexvol
fork
ifconfig
linux
ndmp
netapp
network
nm
ontap
oracle
Performance
perl md5 scripts
pmap
reliability
rpm
Scripts
segv
SIGCLD
size
solaris
sort
sql
storage
strace
swap
sysstat
tpch
tradvol
truss
unix
unix commands
See what SQL is executing in Oracle ‘right now’.
Useful Oracle scripts
space.sql Display tablespace size and current utilisation.
SQL> @/u/little/mycode/sql/dba/space
%
% MaxPoss Max
Tablespace Name KBytes Used Free Used Largest Kbytes Used
------------------- ------------- ------------ ------------ ------ ------------ ------------ ------
m SYSTEM 1,048,576 ...
Read more »