There are probably other/better ways to see what datafiles are being managed by ASM, but this is one way. The command asmcmd lives in the $ORACLE_HOME/bin irectory. In this example I have created an ASM area for my database files, control files etc. By cd’ing to the DATA directory I can...
Read more »
Posts Tagged ‘ oracle ’
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
Use asmcmd to see what’s in the ASM database
See what SQL is executing in Oracle ‘right now’.
select sesion.sid, sesion.username, optimizer_mode, hash_value, address, cpu_time, elapsed_time, sql_text from v$sqlarea...
Read more »
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 »
Oracle for Sysadmins
Set the ‘EDITOR’ variable for the user ‘oracle’. Doing so will allow you to edit your sqlplus commands using a reasonable editor. After executing a piece of SQL in sqlplus, just type ‘edit’ or ‘ed’ and you’ll be transported to your editor. In vi just type :q to get back to the...
Read more »