informatica:oracle:sqlplus
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
informatica:oracle:sqlplus [2015/06/26 10:08] – jose | informatica:oracle:sqlplus [2019/11/06 13:00] (current) – jose | ||
---|---|---|---|
Line 3: | Line 3: | ||
sqlplus "/as sysdba" | sqlplus "/as sysdba" | ||
+ | | ||
+ | Para arrancar: | ||
+ | startup | ||
+ | Para parar: | ||
+ | shutdown inmediate | ||
+ | |||
+ | Para ver con que usuario estamos conectados: | ||
+ | SQL> show user; | ||
+ | USER is " | ||
+ | | ||
+ | Saber en que BBDD estoy: | ||
+ | show parameter db_name | ||
+ | | ||
+ | Version | ||
+ | SELECT * FROM V$VERSION; | ||
+ | SELECT version FROM V$INSTANCE; | ||
+ | |||
+ | Espaco tablespaces | ||
+ | < | ||
+ | COLUMN tsname FORMAT a30 | ||
+ | COLUMN allocation_type FORMAT A4 TRU HEADING ALLO | ||
+ | COLUMN contents FORMAT A4 TRU HEADING MGMT | ||
+ | COLUMN Tot_Size FORMAT 999,999 HEADING " | ||
+ | COLUMN Tot_Free FORMAT 999,999 HEADING " | ||
+ | COLUMN Pct_Free FORMAT 999 HEADING "FREE %" | ||
+ | COLUMN Fragments FORMAT 99,999 HEADING " | ||
+ | COLUMN Large_Ext FORMAT 999,999 HEADING " | ||
+ | set lines 120 | ||
+ | set feedback off pages 999 trims on | ||
+ | SELECT a.tablespace_name TSNAME, SUM(a.tots)/ | ||
+ | SUM(a.sumb)/ | ||
+ | SUM(a.sumb)*100/ | ||
+ | SUM(a.largest)/ | ||
+ | b.contents, b.allocation_type | ||
+ | FROM (SELECt tablespace_name, | ||
+ | MAX(bytes) largest, COUNT(*) chunks | ||
+ | FROM dba_free_space a | ||
+ | GROUP BY tablespace_name | ||
+ | UNION | ||
+ | SELECT tablespace_name, | ||
+ | FROM dba_data_files | ||
+ | GROUP BY tablespace_name | ||
+ | UNION | ||
+ | SELECT tablespace_name, | ||
+ | FROM dba_temp_files | ||
+ | GROUP BY tablespace_name) a, dba_tablespaces b | ||
+ | WHERE b.tablespace_name = a.tablespace_name | ||
+ | GROUP BY a.tablespace_name, | ||
+ | ORDER BY 4 | ||
+ | / | ||
+ | </ | ||
+ | |||
| | ||
====== Editor ====== | ====== Editor ====== | ||
Line 8: | Line 60: | ||
Set pages 1000 | Set pages 1000 | ||
Col < | Col < | ||
+ | | ||
+ | Si la columna es de números: | ||
+ | Col xxxx for 999,999,999 | ||
informatica/oracle/sqlplus.1435313323.txt.gz · Last modified: 2015/06/26 10:08 by jose