Chronicles of 11gR1 on Oracle Enterprise Linux 5 at VMware Workstation 6 on my laptop 1- --- SQL> select * from v$diag_info ; INST_ID NAME VALUE ---------- ---------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1 Diag Enabled TRUE 1 ADR Base /u01/app/oracle 1 ADR Home /u01/app/oracle/diag/rdbms/tong/tong 1 Diag Trace /u01/app/oracle/diag/rdbms/tong/tong/trace 1 Diag Alert /u01/app/oracle/diag/rdbms/tong/tong/alert 1 Diag Incident /u01/app/oracle/diag/rdbms/tong/tong/incident 1 Diag Cdump /u01/app/oracle/diag/rdbms/tong/tong/cdump 1 Health Monitor /u01/app/oracle/diag/rdbms/tong/tong/hm 1 Default Trace File /u01/app/oracle/diag/rdbms/tong/tong/trace/tong_ora_3510.trc 1 Active Problem Count 0 1 Active Incident Count 0 11 rows selected. SQL> alter session set tracefile_identifier = TONGUC ; Session altered. SQL> select * from v$diag_info where name like 'Default Trace%' ; INST_ID NAME VALUE ---------- ---------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1 Default Trace File /u01/app/oracle/diag/rdbms/tong/tong/trace/tong_ora_3510_TONGUC.trc http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN12320 Trace files are sometimes accompanied by corresponding trace map (.trm) files, which contain structural information about trace files and are used for searching and navigation. 2- --- SQL> r 1 SELECT name, value FROM v$system_parameter a 2* WHERE a.NAME IN ( 'db_file_multiblock_read_count', 'memory_max_target', 'memory_target', 'pga_aggregate_target', 'sga_target') sga_target 0 memory_target 423624704 memory_max_target 423624704 db_file_multiblock_read_count 52 pga_aggregate_target 0 MEMORY_TARGET http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams133.htm#REFRN10285 MEMORY_TARGET specifies the Oracle system-wide usable memory. The database tunes memory to the MEMORY_TARGET value, reducing or enlarging the SGA and PGA as needed. DB_FILE_MULTIBLOCK_READ_COUNT Default value The default value corresponds to the maximum I/O size that can be efficiently performed and is platform-dependent http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams053.htm#REFRN10037 FAST_START_MTTR_TARGET Default value 0 http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams079.htm#REFRN10058 WARNING: You are trying to use the MEMORY_TARGET feature. This feature requires the /dev/shm file system to be mounted for at least 847249408 bytes. /dev/shm is either not mounted or is mounted with available space less than this size. Please fix this so that MEMORY_TARGET can work as expected. ORA-00845: MEMORY_TARGET not supported on this system at startup, memory_target needs larger /dev/shm http://blog.tanelpoder.com/2007/08/21/oracle-11g-internals-part-1-automatic-memory-management/ 3- --- create table RECYCLETEST (c1 number) ; ALTER TABLE RECYCLETEST ADD CONSTRAINT pk_RECYCLETEST PRIMARY KEY (c1); CREATE OR REPLACE TRIGGER statement_level AFTER INSERT OR UPDATE OR DELETE ON RECYCLETEST DECLARE vMsg VARCHAR2(30) := 'Statement Level Trigger Fired'; BEGIN IF INSERTING THEN dbms_output.put_line(vMsg || ' When Inserting'); ELSIF UPDATING THEN dbms_output.put_line(vMsg || ' When Updating'); ELSIF DELETING THEN dbms_output.put_line(vMsg || ' When Deleting'); END IF; END statement_level; / drop table recycletest; show recyclebin SQL> ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ---------------- ------------------------------ ------------ ------------------- RECYCLETEST BIN$RwuDZhJDkDXgQKjAMgEaPA==$0 TABLE 2008-02-26:10:31:21 FLASHBACK TABLE RECYCLETEST TO BEFORE DROP; SELECT count(*) FROM user_tables WHERE table_name = 'RECYCLETEST'; COUNT(*) ---------- 1 SELECT constraint_name, status, validated FROM user_constraints WHERE table_name = 'RECYCLETEST'; CONSTRAINT_NAME STATUS VALIDATED ------------------------------ -------- ------------- BIN$RwuDZhJAkDXgQKjAMgEaPA==$0 ENABLED VALIDATED SELECT trigger_name, status FROM user_triggers WHERE table_name = 'RECYCLETEST'; TRIGGER_NAME STATUS ------------------------------ -------- BIN$RwuDZhJCkDXgQKjAMgEaPA==$0 ENABLED drop table RECYCLETEST purge ; 4- --- /u01/app/oracle/product/11.1.0/db_1/sqldeveloper/sqldeveloper.sh SEVERE: Error while registering Oracle JDBC Diagnosability MBean BUG #6362104 http://forums.oracle.com/forums/thread.jspa?messageID=2172498#2172498 5- --- SET SERVEROUTPUT ON; DECLARE l_dad_names DBMS_EPG.varchar2_table; BEGIN DBMS_OUTPUT.put_line('DADs'); DBMS_OUTPUT.put_line('=========='); DBMS_EPG.GET_DAD_LIST (l_dad_names); FOR i IN 1 .. l_dad_names.count LOOP DBMS_OUTPUT.put_line(l_dad_names(i)); END LOOP; END; / select dbms_xdb.gethttpport, dbms_xdb.getftpport from dual; If the port number returns 0, the Oracle XML DB HTTP Server is disabled. To enable Oracle XML DB HTTP server: EXEC DBMS_XDB.SETHTTPPORT(8080); COMMIT; Configuring Oracle HTTP Server Distributed with Oracle Database 11g http://download.oracle.com/docs/cd/B28359_01/install.111/b32006/postcfg.htm#BHAFJJDA For Apex administration workspace http://yourhost:8080/apex/apex_admin For Apex application workspace login http://yourhost:8080/apex/f?p=4550 6- --- FBDA Flashback Data Archiver Process SMCO Space Manager Process RCBG Result Cache: Background DIAn Diagnosibility Process n new V$OSSTAT and V$STATISTICS_LEVEL view statistics, also AWR now include Operating System Statistics - Detail part. some intresting new views V$SQL_CS_HISTOGRAM, V$SQL_CS_SELECTIVITY, V$SQL_CS_STATISTICS, V$SQL_FEATURE, V$SQL_HINT, V$SQL_MONITOR, V$SQL_PLAN_MONITOR, V$IOSTAT_* other- --- * JDBC 4.0 introduces new methods for validating a connection. * tkprof has SQL ID header now, but still sql statemet hierarchy is not completely analysed. * system stats on 11g versus 10g with the same load scenerio; -- 11g SELECT pname, pval1 FROM sys.aux_stats$ WHERE sname = 'SYSSTATS_MAIN'; PNAME PVAL1 ------------------------------ ---------- CPUSPEEDNW 782.362 IOSEEKTIM 10 IOTFRSPEED 4096 SREADTIM 12.23 MREADTIM 7.619 CPUSPEED 782 MBRC 8 MAXTHR 41986048 SLAVETHR 285696 -- 10g PNAME PVAL1 ------------------------------ ---------- CPUSPEEDNW 807,99 IOSEEKTIM 10 IOTFRSPEED 4096 SREADTIM 5,143 MREADTIM 1,705 CPUSPEED 808 MBRC 66 MAXTHR 27383808 SLAVETHR 120832