My Oracle ACE Trophy arrived
Today I received a small package with a warning label "Please handle with care - Glass", inside was my Oracle ACE Trophy :-)
Looks cool on my desk :-)
Looks cool on my desk :-)
See the Check Composite State of Oracle SOA Suite by Command Line ...
Read MoreSee how to startup ir shutdown multiple WebLogic Managed Servers through WLST ...
Read More
-- First lets create the Application Schema APP_USER create user APP_USER identified by mysecrectpassword; grant connect, create table to APP_USER; create role APP_READ; -- Secondly create the Enduser EVIL create user EVIL identified by evilpassword; grant connect, app_read to EVIL; -- Thirdly create the Enduser FRIENDLY create user FRIENDLY identified by friendlypassword; grant connect, app_read to FRIENDLY; -- Connect with the Application Schema APP_USER -- Create one table -- and asign the select right to the Application Role APP_READ conn app_user/mysecretpassword create table t1 as select * from all_objects; grant select on t1 to APP_READ;
conn evil/evilpassword
exec sys.dbms_snapshot.BEGIN_TABLE_REORGANIZATION('APP_USER','T1');
conn friendly/friendlypassword select * from APP_USER.T1;The session from the user FRIENDLY is not responding :-( The session from user FRIENDLY will only responding when we are running following SQL Statement in the session of user EVIL:
-- Session of user EVIL
exec sys.dbms_snapshot.END_TABLE_REORGANIZATION('APP_USER','T1');
-- Some errors will come up, as the used table
-- have not a materialized view log
ERROR at line 1:
ORA-23413: table "APP_USER"."T1" does not have a materialized view log
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_SNAP_INTERNAL", line 703
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2811
ORA-06512: at line 1
set linesize 200 col name format a20 select (select tablespace_name from dba_tablespaces where tablespace_name = b.tablespace_name ) name ,round(kbytes_alloc/1024, 2) mbytes ,round((kbytes_alloc-nvl(kbytes_free,0))/1024, 2) used ,round(nvl(kbytes_free,0)/1024, 2) free ,round(((kbytes_alloc-nvl(kbytes_free,0))/ kbytes_alloc)*100, 2) pct_used ,round(nvl(largest,0)/1024, 2) largest ,round(nvl(kbytes_max,kbytes_alloc)/1024, 2) max_size ,round(decode(kbytes_max,0,0,((kbytes_alloc-nvl(kbytes_free,0))/kbytes_max)*100),2) pct_max_used ,(select extent_management from dba_tablespaces where tablespace_name = b.tablespace_name) extent_management ,(select segment_space_management from dba_tablespaces where tablespace_name = b.tablespace_name) segment_space_management from (select sum(bytes)/1024 Kbytes_free, max(bytes)/1024 largest, tablespace_name from sys.dba_free_space group by tablespace_name ) a ,(select sum(bytes)/1024 Kbytes_alloc, sum(maxbytes)/1024 Kbytes_max, tablespace_name from sys.dba_data_files group by tablespace_name union all select sum(bytes)/1024 Kbytes_alloc, sum(maxbytes)/1024 Kbytes_max, tablespace_name from sys.dba_temp_files group by tablespace_name )b where a.tablespace_name (+) = b.tablespace_name order by 2;
And the result should look like as follows:
NAME MBYTES USED FREE PCT_USED LARGEST MAX_SIZE PCT_MAX_USED EXT_MANAGE SEGMENT_SPACE ------------ ---------- ---------- ---------- ---------- ---------- ---------- ------------ ------------ ---------- TOOLS 10 .062 9.93 .62 9.93 65535.96 0 LOCAL AUTO DRSYS 20 12.56 7.43 62.81 7.18 65535.96 .02 LOCAL AUTO USERS 25 7.06 17.93 28.25 17.93 65535.96 .01 LOCAL AUTO INDX 25 .06 24.93 .25 24.93 65535.96 0 LOCAL AUTO XDB 103.75 103.5 .25 99.75 .25 65535.96 .16 LOCAL AUTO TEMP 256 256 0 100 0 0 0 LOCAL MANUAL UNDOTBS1 636 85.31 550.68 13.41 189.93 32768 .26 LOCAL MANUAL SYSAUX 1024 480.68 543.31 46.94 502.87 1024 46.94 LOCAL AUTO SYSTEM 1024 675.31 348.68 65.94 347.93 65535.96 1.03 LOCAL MANUALUnder the column PCT_MAX_USED you can see the percentage usage in consideration with the maxsize of the datafile(s) and under the column PCT_USED you can see the actual percentage usage calculated according to the actual datafile(s) size.
create sequence seq_t1_id start with 1; create table t1 (id number, col1 varchar2(20)); insert into t1 values (seq_t1_id.nextval, 'Test Value expected 1'); commit; select * from t1; ID COL1 ---------- -------------------- 2 Test Value expected 1
create sequence seq_t1_id start with 1; create table t1 (id number, col1 varchar2(20)); ALTER SESSION SET EVENTS '14403 trace name errorstack level 3'; insert into t1 values (seq_t1_id.nextval, 'Test Value expected 1'); commit;
Tue Jan 25 16:54:19 2011 Errors in file e:\oracle\diag\rdbms\xxx\xxx\trace\xxx_ora_6072.trc: ORA-14403: cursor invalidation detected after getting DML partition lock Tue Jan 25 16:54:26 2011 Trace dumping is performing id=[cdmp_20110125165426]
Is it possible to define one logfile for multiple Managed Server and the global Domain Logfile? So that I don't have to go through multiple logfiles for investigation of problems or errors
echo off SETLOCAL set DOMAIN_NAME=DemoDomain set USERDOMAIN_HOME=D:\oracle\fmw-11.1.1\user_projects\domains\DemoDomain set SERVER_NAME=DemoAdminServer set PRODUCTION_MODE=true set JAVA_VENDOR=BEA set JAVA_HOME=D:\oracle\fmw-11.1.1\jrmc-4.0.1-1.6.0 set MEM_ARGS=-Xms256m -Xmx512m call "D:\oracle\fmw-11.1.1\wlserver-10.3.3\server\bin\installSvc.cmd" ENDLOCAL
"%WL_HOME%\server\bin\beasvc" -install -svcname:"beasvc %DOMAIN_NAME%_%SERVER_NAME%" -javahome:"%JAVA_HOME%" -execdir:"%USERDOMAIN_HOME%" -maxconnectretries:"%MAX_CONNECT_RETRIES%" -host:"%HOST%" -port:"%PORT%" -extrapath:"%EXTRAPATH%" -password:"%WLS_PW%" -cmdline:%CMDLINE%
Copyright ©
Dirk Nachbar: This Blog is discontinued, its only read-only | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by NewBloggerThemes.com