Diferencia entre revisiones de «Oracle»
De gacq wiki
| Línea 12: | Línea 12: | ||
= SQLplus = | = SQLplus = | ||
http://lbdwww.epfl.ch/f/teaching/courses/oracle8i/server.815/a66736/toc.htm | http://lbdwww.epfl.ch/f/teaching/courses/oracle8i/server.815/a66736/toc.htm | ||
| + | |||
| + | =Monitoring= | ||
| + | ==Not checked== | ||
| + | *http://asktom.oracle.com/~tkyte/Misc/free.html | ||
| + | * | ||
| + | |||
| + | List free and used space in database: | ||
| + | SELECT sum(bytes)/1024 "free space in KB" FROM dba_free_space ORDER BY TABLESPACE_NAME; | ||
| + | SELECT sum(bytes)/1024 "used space in KB" FROM dba_segments ORDER BY TABLESPACE_NAME; | ||
Revisión del 15:10 8 oct 2006
Administracion
START/STOP
como essdbo
$ORACLE_HOME/bin/dbstart $ORACLE_HOME/bin/lsnrctl start $ORACLE_HOME/bin/dbshut $ORACLE_HOME/bin/lsnrctl stop
SQLplus
http://lbdwww.epfl.ch/f/teaching/courses/oracle8i/server.815/a66736/toc.htm
Monitoring
Not checked
List free and used space in database: SELECT sum(bytes)/1024 "free space in KB" FROM dba_free_space ORDER BY TABLESPACE_NAME; SELECT sum(bytes)/1024 "used space in KB" FROM dba_segments ORDER BY TABLESPACE_NAME;
