SR 4 DB

El amigo Eduardo desde Venezuela pregunta como puedo saber quien bloqueo el acceso de un usuario a la base de datos por intentos inválidos. (ORA- 1017  password incorrecto o ORA- 28000  usuario bloqueado). Por su puesto se necesita tener la auditoria encendida. ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'; COL OS_USERNAME FOR A12 COL USERNAME  FOR A20 COL USERHOST FOR A12 COL TERMINAL  FOR A12 COL ACTION_NAME FOR A12 SELECT * FROM ( select OS_USERNAME, USERNAME, USERHOST, TIMESTAMP, OS_PROCESS,RETURNCODE  from  dba_audit_session  WHERE  RETURNCODE in (1017,28000)  AND USERNAME =upper('&vUsername') ORDER BY TIMESTAMP DESC )  WHERE  ROWNUM <= 10; Saludos.

set lin 120 set pages 20 col program for a42    COL max_op_cur FOR 999999 HEADING 'Max. Open C.|per Session' COL sum_op_cur FOR 999999 HEADING 'Total. Open C.|per Program' COL avg_op_cur FOR 999999 HEADING 'Avg. Open C.|per Program' --- Opened Cursors Current select program, max_op_cur , sum_op_cur , avg_op_cur , sessions from (select   s .program, max(t.value) max_op_cur ,   sum( t.VALUE) sum_op_cur , round(avg(t.value)) avg_op_cur , count( 1 ) sessions from v$sesstat t, V$STATNAME n , v$session s where t. STATISTIC# = n . STATISTIC#  and   n .name in ( 'opened cursors current' ) and t.sid= s .sid group by s .program order by max(t.value) desc ) where rownum< 10 ; COL PROGRAM FOR A32 COL USERNAME FOR A16 COL MACHINE FOR A24 COL OSUSER FOR A16 ALTER SESSION SET NLS_DATE_FORMAT= 'DD-MON-YYYY HH24:MI:SS' ; SET PAGES 200 SET LIN 120   select s

SQLPROMPT &_user : Who is connected (10g and +). &_CONNECT_IDENTIFIER : Which Database you are connected. Eg : SQL> set sqlprompt   '&_CONNECT_IDENTIFIER@&_user>' PADOVA@SYS > TRIMSPOOL – TRIMOUT SET  TRIMOUT ON or SET  TRIMSPOOL ON removes trailing blanks at the end of each displayed or spooled line. SQL> set lin 80 SQL> set TRIMSPOOL OFF SQL> spool prueba04 . txt SQL> select '12345' cmp from dual ; cmp ----- 12345 SQL>   spool off; bash - 3.2 $  wc - c prueba04 . txt        293 prueba04 . txt < ----- 293 characters SQL> set lin 80 SQL> SET TRIMSPOOL ON SQL> spool prueba02 . txt SQL>   select '12345' cmp from dual ; cmp ----- 12345 SQL>   spool off; bash - 3.2 $ wc - c prueba02 . txt        69 prueba02 . txt    < ----- just 69 characters GLOGIN.SQL $ORACLE_HOME/sqlplus/admin/glogin.sql All

Problema:   Luego de una carga de datos realizada con sqlloader DIRECT=TRUE los índices se invalidan y muestran  estatus "UNUSABLE". Caso de Prueba: Creamos una tabla con un índice que no permita valores duplicados; SQL> create table hr.test_loader (id number, field01 varchar2(12)) tablespace USERS; Table created. SQL> create unique index hr.pk_test_loader on hr.test_loader(id) tablespace USERS; Index created. Verificamos el estatus del índice. SQL> select status from dba_indexes where index_name='PK_TEST_LOADER'; STATUS -------- VALID Realizamos la primera carga de datos con el SQLLOADER. sqlldr system/********* direct=true control=control.ctl log=mylogfile.log bad=mybadlog.bad data=mydatafile.txt Archivo:       control.ctl  load data infile * into table hr.test_loader fields terminated '|' (id,field01) Archivo:       mydatafile.txt 1|AAAAA 2|BBBBB 3|CCCCC 4|DDDD

---***************************** ---*  Commits Class Info       * ---*  By Eini Trujillo. Vzla   * ---*  July 2014                * ---* Created : 12/08/2014      * ---* Updated : 02/09/2014      * ---* version 1.01              * ---***************************** PROMPT PROMPT ----- Redo Log Files SET LIN 120 set verif off set echo off SET FEEDBACK off set timing off set time off COL MEMBER FOR A64 HEADING "Redo Log File" COL WARNING FOR A11  HEADING "Multiplexed" JUS CENTER COL DAY FOR A12 COL Max_Redo_perHour FOR 9999 HEADING "Max. RedoLog Switch|per  Hour" COL Avg_Redo_perHour FOR 9999 HEADING "Avg. RedoLog Switch|per Hour" COL Avg_Min_Switch FOR 9999 HEADING "Avg. RedoLog Switch Time|(Min)" COL Size_MB FOR 999999 HEADING "Size MB" COL Avg_Redo_perDay FOR 999 , 999 HEADING "Avg. RedoLog| Switch per Day"   JUS CENTER COL Avg_SizeDay