dba:oracle:basic_oracle_sql_querys
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
dba:oracle:basic_oracle_sql_querys [2023/02/10 15:25] – [SECCIÓN : STATUS] dodger | dba:oracle:basic_oracle_sql_querys [2023/02/10 15:26] – [[SECTION] Usuarios] dodger | ||
---|---|---|---|
Line 141: | Line 141: | ||
</ | </ | ||
El event 10046 está sacado de Doc ID 1198753.1 (para rman), se puede usar cualquier otro | El event 10046 está sacado de Doc ID 1198753.1 (para rman), se puede usar cualquier otro | ||
- | ======SECCIÓN : Configuración====== | + | ====== |
=====Nombre de la bd===== | =====Nombre de la bd===== | ||
<code sql>show parameter db_name ;</ | <code sql>show parameter db_name ;</ | ||
Line 246: | Line 246: | ||
- | ======SECCIÓN : Storage====== | + | ====== |
=====Listar tablespaces===== | =====Listar tablespaces===== | ||
Line 1039: | Line 1039: | ||
- | ======SECCIÓN : Usuarios====== | + | ====== |
=====Listar===== | =====Listar===== | ||
* Todos: | * Todos: | ||
Line 1378: | Line 1378: | ||
ALTER USER USERNAME PROFILE LIMIT ; | ALTER USER USERNAME PROFILE LIMIT ; | ||
</ | </ | ||
- | ======SECCIÓN : Objetos====== | + | ====== |
===== Compilar ===== | ===== Compilar ===== | ||
Line 1837: | Line 1837: | ||
- | ======SECCIÓN : Sesiones====== | + | ====== |
=====Listar numero de sesiones===== | =====Listar numero de sesiones===== | ||
<code sql> | <code sql> | ||
Line 2329: | Line 2329: | ||
/ | / | ||
</ | </ | ||
- | ======SECCIÓN : QUERYS====== | + | ====== |
====longest querys==== | ====longest querys==== | ||
Line 2408: | Line 2408: | ||
; | ; | ||
</ | </ | ||
- | ======SECCIÓN : Execution PLANS====== | + | ====== |
===== Hidden options/ | ===== Hidden options/ | ||
Line 2495: | Line 2495: | ||
* http:// | * http:// | ||
* http:// | * http:// | ||
- | ======SECCIÓN : Performance====== | + | ====== |
===== Hard parse ===== | ===== Hard parse ===== | ||
* How to Identify Hard Parse Failures (Doc ID 1353015.1) | * How to Identify Hard Parse Failures (Doc ID 1353015.1) | ||
Line 2680: | Line 2680: | ||
</ | </ | ||
- | ======SECCIÓN : Otros====== | + | ====== |
===== Añadir un redo group ===== | ===== Añadir un redo group ===== | ||
Line 3056: | Line 3056: | ||
- | ======SECCIÓN : Documentos adicionales====== | + | ====== |
=====Auditoria===== | =====Auditoria===== |
dba/oracle/basic_oracle_sql_querys.txt · Last modified: 2023/07/03 08:37 by dodger