SQL_TRACE in v$session will tell you for active 10053 or 10045 trace are enabled or not :
SQL_TRACE VARCHAR2(8) Indicates whether SQL tracing is enabled (ENABLED) or disabled (DISABLED)
Suscribirse a:
Enviar comentarios (Atom)
skip to main |
skip to sidebar
Ingeniero de Sistemas con énfasis en Infraestructura IT especialización en Gerencia de Proyectos, Instructor y Especialista Oracle Certificate 10G - 11G, 12C Experiencia Oracle 8I 9I 10G 11G 12C OCA - OCP Experiencia (Real Application Cluster) Cloud Control 12C - (Data Guard) Oracle WebLogic, Certificate ITIL V3, Experiencia en Plataformas Unix-AIX-HPUX-SUN-Linux, Admon (OAS - BEA WEBLOGIC) programación PL/SQL Power Builder, C++, Informix R4gl, Oracle PL/SQL, BI (COGNOS – HYPERION)
Vistas de página en total
Buscar este blog
Seguidores
Datos personales
Archivo del blog
-
►
2020
(170)
- ► septiembre (4)
-
►
2019
(48)
- ► septiembre (2)
-
►
2017
(39)
- ► septiembre (13)
-
►
2016
(49)
- ► septiembre (1)
-
►
2015
(66)
- ► septiembre (4)
-
►
2014
(30)
- ► septiembre (1)
-
►
2013
(18)
- ► septiembre (1)
-
►
2012
(35)
- ► septiembre (2)
-
►
2011
(33)
- ► septiembre (3)
-
►
2010
(33)
- ► septiembre (3)
-
►
2009
(84)
- ► septiembre (32)
INSTRUCTOR WDP
Entradas populares
-
Recovery Manager: Release 12.1.0.1.0 - Production on Thu Sep 6 21:24:48 2018 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All...
-
Startup of RAC database fails with ORA-01105 & ORA-01677 Problem Description Oracle Data Guard was setup between two RAC database...
-
RMAN> RMAN> list backup of archivelog logseq=120316; RMAN> list backup of archivelog logseq 120316; RMAN> list backup of archiv...
-
Online Table Redefinition Examples For the following examples, see Oracle Database PL/SQL Packages and Types Reference for descriptions of a...
-
Displaying Index Code From time to time you’ll need to drop an index. This could be because of an obsolete application or you’ve est...
Oracle Seguridad
Etiquetas
- 11g RAC Administration and Maintenance Tasks and Utilities (1)
- Activar Mode Archivelog Oracle (1)
- AFTER SUSPEND Trigger (1)
- ARCHIVE ERROR (1)
- Auditoria Oracle (1)
- AUMENTAR TAMAÑO REDOLOGS (1)
- AutoNumber Table And Identity Functionality Trigger (1)
- Backing Up in NOARCHIVELOG Mode: Example (1)
- Backup ASM using RMAN (1)
- Backup del controlfile (1)
- BACKUPS CREAR DATAGUARD (1)
- BAJAR SERVICIOS DATAGUARD (1)
- Basic Enterprise Manager EMCA (1)
- CAMBIAR PROMPT SQLPLUS (1)
- CATALOGOS RMAN (1)
- Centos Vbox Guest Aditions (1)
- Checking the Hardware Requirements (1)
- Checking the Network Setup (1)
- Checking the Software Requirements (1)
- Clusterware (1)
- Comandos Solaris (1)
- Configuracion Archivos Oracle (1)
- CONFIGURACION DATAGUARD BROKER (1)
- Configuracion de Red Cluster Oracle (1)
- Configuring Kernel Parameters (1)
- CREAR TABLA VACIA (1)
- Crear y Formatear Particiones en Linux (1)
- CREATE TABLESPACE TEMPORAL 11G (1)
- Creating Required Operating System Groups and Users (1)
- Data Guard implementation for Oracle 10gR2 (1)
- DATA MASKING (1)
- DATAGUARD (1)
- DataGuard How to Resolve Primary/Standby Log GAP In Case of Deleting Archivelogs From Primary? (1)
- DATAGUARD PASO A PASO (1)
- DATAGUARD SCRIPTS SQL PARA VALIDAR ESTADO (1)
- DATAGUARD SWITCHOVER (1)
- DATAPROTECTOR HP (1)
- DATE FUNCTIONS (1)
- DBMS_SHARED_POOL package Objetos en Memoria (1)
- Debug PL/SQL (1)
- DETERMINE OPTIMAL SIZE FOR REDO LOGS (1)
- DGMGRL (1)
- Diferencia Entre DDL (1)
- DML and DCL commands? (1)
- DUPLICATE (1)
- Duplicate RMAN - VERITAS (1)
- Ejemplo Mover Tabla No particionada a una Tabla Particionada DBSMS_REDEFINITION (40)
- Ejemplos Manejo de Tablespaces (1)
- Examples of Using Data Pump Export (1)
- Examples Oracle Online Table Redefinition (1)
- Faster Recovery (1)
- Funcion Complejidad Clave Oracle 10g (1)
- FUNCTION SQL Examples (1)
- GENERAR ARCHIVOS CSV (1)
- Grid Control (1)
- History of Oracle Corporation. (1)
- How does one select the LAST N rows from a table? (1)
- How Select the TOP N rows from a table? (1)
- How to convert non-partitioned table to partition table using re-definition (1)
- How To Move The Database To Different Diskgroup Migrating from External Redundancy to Normal Redundancy (1)
- How to put dumps in multiple locations (1)
- Identifying Required Software Directories (1)
- Instalacion Oracle 11g Solaris 64 Bits (1)
- Instalation (1)
- Installing the NetBackup Agent for Oracle (1)
- JOINS (1)
- Laboratorio List Incarnation (1)
- Laboratorio Oracle Redologs (1)
- Laboratorios Flashback (1)
- Laboratorios Recovery RMAN (1)
- LIBROS INTERNET (1)
- Making User-Managed Backups of Offline Tablespaces and Datafiles (1)
- Managing Audit Trails ASM (1)
- Manually Resolving a Gap (1)
- Matar Puerto Linux (1)
- Migracion de File System +ASM (1)
- Migrating Oracle10g Database to Automatic Storage management (ASM) (1)
- MOVER AUD$ FGA_LOG$ (1)
- Multiple Temporary Tablespaces (1)
- OEM Grid Control Maintenance Tasks (1)
- Opatch Invoking OPatch (1)
- Oracle 10g Automatic Storage Management (ASM) (3)
- Oracle 10g Copiar una base de datos Windows (1)
- ORACLE 10G Variables de Ambiente (1)
- Oracle 11g Database Replay (1)
- Oracle 11g Flashback Data Archive (Oracle Total Recall) (1)
- Oracle 11g New Features (1)
- Oracle 11g Query Result Cache (1)
- Oracle 11gR2 Physical Standby Database (1)
- Oracle 1OG Performance and Tuning (1)
- Oracle Administración de Logs (1)
- Oracle Application Server 10g (1)
- Oracle Application Server 10G R3 (1)
- Oracle Clusterware R2 Scan DNS (1)
- Oracle Crear Trace Sentencias SQL (1)
- Oracle Data Guard (1)
- Oracle Data Guard Broker configuration example (1)
- Oracle Database 10g Conceptos Procesos en Memoria (1)
- Oracle Database 10g Configuracion Herramienta Power (1)
- Oracle Database 10g Export (1)
- Oracle Database 10g Parametros de Arranque (1)
- Oracle Database 10g Querys Plan de Ejecucion (1)
- Oracle Database 10g Release 2 (10.2.0.2) Installation On Solaris 10 (x86) (1)
- Oracle Database 10g Tareas Administrador (1)
- Oracle DataGuard (1)
- ORACLE FGA (1)
- Oracle Flashback Database (1)
- Oracle Flashback Query (1)
- Oracle Full Text Indexing using Oracle Text (1)
- Oracle LockDown (1)
- Oracle Mode Shutdown (1)
- Oracle Multi-master Replication (1)
- ORACLE PACKAGE DBMS_APPLICATION_INFO (8)
- Oracle Papelera Reciclaje (1)
- Oracle RAC Apuntes Curso (1)
- Oracle RAC Comands (1)
- ORACLE Recompiling Invalid Schema Objects (1)
- ORACLE Renaming or Moving Oracle Files (1)
- Oracle Repair Table Block Detecting Corruption (1)
- Oracle Restore Point Laboratorio (1)
- Oracle Secrets Database (1)
- Oracle Seguridad Script Determinar Usuario y Password Igual (1)
- Oracle Shell Scripting Unix (1)
- Oracle Sqlplus Unix Shell (1)
- Oracle Text (1)
- Oracle Uso de Logminer (1)
- ORACLE Usuario que Ejecuto Sentencia SQL a Partir del SQL_ID (1)
- Oracle UTL_MAIL (1)
- Oracle Violacion de Politicas (1)
- PL/SQL wrapper (1)
- Procesos en Memoria (1)
- Proyecto Seguridad Bases de Datos Oracle (1)
- Purging statistics from the SYSAUX tablespace (1)
- RAC Voting Disk Problem (1)
- Raid 1 en Linux (1)
- Raid 5 Linux (1)
- Recovery (1)
- REFRESH VISTAS MATERIALIZADAS (1)
- Renaming ASM Disk group in Oracle 11gR2 (1)
- Repositorio Oracle Linux (1)
- Restore and Recover database to a new host (1)
- Restore Incarnation (1)
- RESTORE TAPE (1)
- Restrict DDL on a Schema (1)
- Rman Backup Tape Veritas (1)
- RMAN Backups (1)
- RMAN Configuration Enviroment (1)
- RMAN Creacion Scripts (1)
- RMAN Creating a High-Availability Recovery Catalog (1)
- RMAN CREATING AND FIXING BLOCK CORRUPTION (1)
- RMAN Drop Database (1)
- RMAN Duplicate Windows (1)
- RMAN Duplicating Databases and Transporting Data (1)
- RMAN EXAMPLES RECOVER (1)
- RMAN Faster Backup (1)
- RMAN list backup Generar Archivo Backups (1)
- RMAN Maintaining RMAN Backups Repository (1)
- RMAN on Windows (1)
- RMAN Performing Complete Recovery (1)
- RMAN Performing Flashback Recovery (1)
- RMAN Performing Incomplete (1)
- RMAN Recovery (1)
- RMAN Recovery ORACLE_SID Diferente Unix (1)
- RMAN Redo Log Failures (1)
- RMAN Restoring the Control File (1)
- RMAN Script Backup Disk - Tape (1)
- RMAN Scripting (1)
- Rman Scripts Disk (1)
- RMAN Troubleshooting (1)
- RMAN Tuning (1)
- RMAN Using Recovery Advisor (1)
- RMAN Using the Flash Recovery Area (2)
- RMAN Veritas Duplicate TAPE (1)
- Roles y Privilegios (1)
- Running the DBVERIFY Utility (1)
- Script Export (1)
- SEARCHING FOR ERRORS IN THE ALERT.LOG FILE (1)
- Seguridad Oracle 10G Usuarios con el Password igual que el Username (1)
- Seguridad Oracle y Funcion Complejidad Clave (1)
- set define [SQL*Plus] (1)
- Single Instancia TO RAC (1)
- Solaris 10 (1)
- Solaris 10 ACTIVAR SMTP (1)
- Solaris 10 Manejo de Zonas (1)
- Solaris 10 Raw Devices (1)
- Solaris SUN Servicios Cluster (1)
- Solaris Zonas (1)
- SQLNET (1)
- SQLSERVER CREATE TRIGGER (1)
- STARTING RMAN (1)
- Statspack (1)
- Switching Datafile Filenames After a Restore: (1)
- SYS_CONTEXT (2)
- TABLAS PARTICIONADAS (1)
- TKPROF And Oracle Trace (1)
- Transparent Data Encryption (1)
- Transporting Tablespaces on the Same OS Platform (1)
- Tuning RMAN Backup Performance: Procedure (1)
- Ubuntu 10.04 (1)
- Ubuntu Instalacion VirtualBox (1)
- Ubuntu Mounting Linux Partitions (1)
- UNIX and Linux (Method 1) (1)
- Unix Comandos Examples (1)
- Updating a table based on another table (1)
- Using RMAN (1)
- Using the Recovery Catalog (1)
- VI Sustituir y Reemplazar (1)
- VIEW WITH CHECK OPTION (1)
- VirtualBox (1)
- What Are the Basic Steps in Using the Data Pump API? (1)
Archivo del blog
-
►
2020
(170)
- ► septiembre (4)
-
►
2019
(48)
- ► septiembre (2)
-
►
2017
(39)
- ► septiembre (13)
-
►
2016
(49)
- ► septiembre (1)
-
►
2015
(66)
- ► septiembre (4)
-
►
2014
(30)
- ► septiembre (1)
-
►
2013
(18)
- ► septiembre (1)
-
►
2012
(35)
- ► septiembre (2)
-
►
2011
(33)
- ► septiembre (3)
-
►
2010
(33)
- ► septiembre (3)
-
►
2009
(84)
- ► septiembre (32)
OCP 11G
OCA11G
SQL
WEBLOGIC
OCA 10G
OCP 10G
No hay comentarios:
Publicar un comentario