locutoriorama

--total cursors open, by session select a.value, s.username, s.sid, s.serial# from v$sesstat a, v$statname b, v$session s where a.statistic# = b.statistic#  and s.sid=a.sid and b.name = 'opened cursors current'; --total cursors open, by username & machine select sum(a.value) total_cur, avg(a.value) avg_cur, max(a.value) max_cur, s.username, s.machine from v$sesstat a, v$statname b, v$session s where a.statistic# = b.statistic#  and s.sid=a.sid and b.name = 'opened cursors current' group by s.username, s.machine order by 1 desc; select c.user_name, c.sid, sql.sql_text from v$open_cursor c, v$sql sql where c.sql_id=sql.sql_id  -- for 9i and earlier use: c.address=sql.address and c.sid=&sid ;    

Importar un esquema, sin eliminarlo previamente, es un refresco de sólo las tablas. Utilizo el parámetro de import TABLE_EXISTS_ACTION=REPLACE, para que borre las tablas que ya existen y las importe. DIRECTORY=data_pump_dir LOGFILE=log_import_01.log DUMPFILE=TOTALTPOR10.DMP SCHEMAS=UA_PORTAL TABLE_EXISTS_ACTION=REPLACE

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/ds_admin.htm#sthref4197  ALTER SESSION CLOSE DATABASE LINK linkname ;    dbms_session.close_database_link(dblink IN VARCHAR2);   Duran lo que dura la sesión. Nota: una SELECT a través de database link, utiliza undo. Para liberalo hay que hacer commit o rollback.

set password = password ('nuevapassword');

COL df_name FORMAT a20 COL tbsp_name FORMAT a10 COL status FORMAT a7 COL error FORMAT a10 SELECT r.FILE# AS df#, d.NAME AS df_name, t.NAME AS tbsp_name,        d.STATUS, r.ERROR, r.CHANGE#, r.TIME FROM V$RECOVER_FILE r, V$DATAFILE d, V$TABLESPACE t WHERE t.TS# = d.TS# AND d.FILE# = r.FILE# /