Performance bug on oracle 11g I had been months trying to find a bug in performance after I migrate to 11gr2 and finally I found, in theory it is solved in 11gr2 patch 3

this triggers check and solved the problem, or execute from the beginning, to validate the change.

 select pname,pval1 from sys.aux_stats$
    where pname like '%READTIM';


CREATE OR REPLACE TRIGGER TGR_FIX_SYSTEM_STATS
 AFTER
 LOGON
 ON DATABASE
BEGIN

FOR A IN ( SELECT PNAME,PVAL1
   FROM SYS.AUX_STATS$
  WHERE SNAME = 'SYSSTATS_MAIN'
    AND  PNAME IN ('SREADTIM','MREADTIM') ) LOOP
  IF (A.PVAL1 > 75) THEN
    DBMS_STATS.SET_SYSTEM_STATS(A.PNAME, a.PVAL1 / 10000);
    DBMS_OUTPUT.PUT_LINE('MREADTIM ALTERED TO: ' || a.PVAL1 / 10000);
  END IF;
END LOOP;
COMMIT;

EXCEPTION WHEN OTHERS THEN
 DAZ.DB_ERR_GRABA(0,'tgr_fix_system_stats'||SQLERRM);
END;
/  ¶ 9:32 AM 0 comments

  JAVAFX replaces Swing If you are thinnking to use swing to program don't do it use java fx, you can use java fx on swing too.

6. Is JavaFX replacing Swing as the new client UI library for Java SE?
Yes. However, ---

http://www.oracle.com/technetwork/java/javafx/overview/faq-1446554.html


swing 2 download new features
swing 3 download new features  ¶ 8:56 AM 0 comments

 

Solved: oracle.jbo.NoDefException: JBO-25058: Definition xxx of type Attribute not found in xxx

Note: I didn't refactor neither done intentionally a change, as I remember (this is my test proyect where I'm testing)

I got the message

oracle.jbo.NoDefException: JBO-25058: Definition RfdRef of type Attribute not found in RfdRef


First try:
I dropped rfdRef in view and entity, and then I got the following message, for the other field

oracle.jbo.NoDefException: JBO-25058: Definition RfdDesc of type Attribute not found in RfdDesc

at oracle.jbo.uicli.binding.JUCtrlValueBinding.getAttributeDef(JUCtrlValueBinding.java:512)
at oracle.jbo.uicli.binding.JUCtrlValueBinding.getAttributeDef(JUCtrlValueBinding.java:2539)
at oracle.adfinternal.view.faces.model.binding.FacesCtrlAttrsBinding.getType(FacesCtrlAttrsBinding.java:106)
at oracle.adfinternal.view.faces.model.AdfELResolver.getType(AdfELResolver.java:55)
at javax.el.CompositeELResolver.getType(CompositeELResolver.java:215)
Truncated. see log file for complete stacktrace
oracle.jbo.NoObjException: JBO-25003: Object AppModuleDataControl of type View Object not found
at oracle.adf.model.binding.DCIteratorBinding.getViewObject(DCIteratorBinding.java:1478)
at oracle.adf.model.binding.DCIteratorBinding.initSourceRSI(DCIteratorBinding.java:1660)
at oracle.adf.model.binding.DCIteratorBinding.callInitSourceRSI(DCIteratorBinding.java:1625)
at oracle.adf.model.binding.DCIteratorBinding.internalGetRowSetIterator(DCIteratorBinding.java:1601)
at oracle.adf.model.binding.DCIteratorBinding.refresh(DCIteratorBinding.java:4202)
Truncated. see log file for complete stacktrace

Note:
going to bindings in my jspx page, I note when I tried to create an atribute value, the attribute list was empty.
 

I restore backup

Second Try I remember I was checking the  abmPageDef.xml 

And found two difference.

iterator Binds="RefDefView1" RangeSize="25""
iterator Binds="AppModuleDataControl" RangeSize="25""

ChangeEventPolicy="ppr"/>
ChangeEventPolicy="ppr" RowCountThreshold="0"/>

I restored backup of the file  abmPageDef.xml  and all is ok.

Other occurrence of the same error.

I got the same error, and after it, an error indicating in the view wasn't the primary key on a field is not and never had been a primary key, I synchronized the entity with the database, and all is ok (right click on entity Synchronize with Database...)

Labels: jdeveloper

  ¶ 9:42 AM 0 comments

  Can't set streams_pool_size to zero?

If you are using spfile, pre-optimized values are saved on the spfile, if you restart the database, they don't have to be recalculated again.

This are real values and can block you from setting them to zero, for example, after an upgrade.
this command will not work.
alter system set streams_pool_size=0 scope=both sid='xxx';

The reason are the following parameter you must set to zero before.
alter system set "__streams_pool_size"=0 scope=both sid='xxx';
alter system set "__shared_pool_size"=0 scope=both sid='xxx';
alter system set "__large_pool_size"=0 scope=both sid='xxx';
alter system set "__java_pool_size"=0 scope=both sid='xxx';

Remember this values in the same way as the normal parameter (__java_pool_size and java_pool_size) set the minimum value is you are using automatic memory management.  ¶ 4:49 AM 0 comments

  WARNING FOR ORACLE STANDARD DATABASE USERS,
10G TUNING FEATURES RESTRICTIONS!!!!

Hi,
If you are Oracle Standard Database user, you had heard about new tunning features like access and Sql Access advisors.
Now you must know you can't use them.

To use this packs you must have a separate license AND you MUST be using Oracle Enterprise Edition.

1) If you are using Database Control, the first time you connect using SYSMAN, you must disable that features.
2) You must be aware you can use these packages too from the Database
The usage of this features is registered in the database
For example:
Views
V$ACTIVE_SESSION_HISTORY
DBA_HIST_*
DBA_ADVISOR_*
MGMT$*
packages
DBMS_SQLTUNE,DBMS_ADVISOR,DBMS_WORKLOAD_REPOSITORY
Scripts
awrrpt.sql, awrrpti.sql, addmrtp.sql, addmrpti.sql,
awrrpt.sql, awrrpti.sql, addmrpt.sql, addmrpti.sql, ashrpt.sql, ashrpti.sql,
awrddrpt.sql, awrddrpi.sql, awrsqrpi.sql, awrsqrpt.sql, sqltrpt.sql.
Other Database Control features
Oracle Configuration Management Pack
¦ Database and Host Configuration
¦ Deployments
¦ Search configuration
¦ Compare configuration
¦ Policies, including Security checks and scoring

The detailed information is in online documentation
http://www.oracle.com/pls/db102/portal.portal_db?selected=3

Oracle® Database Licensing Information
10g Release 2 (10.2)
B14199-03
http://www.oracle.com/pls/db102/to_pdf?pathname=license.102%2Fb14199.pdf&remark=portal+%28Books%29  ¶ 6:13 AM 0 comments

  Solving definetively the mutation error on triggers ORA-04091: table X is mutating

I had several times this error, to get the creation of a historic table of modifications.
This problem is simply solved adding three lines

PRAGMA AUTONOMOUS_TRANSACTION; <-- You have to add this 1/3
COMMIT; <-- You have to add this 2/3
ROLLBACK; <-- You have to add this 3/3

For example:

CREATE OR REPLACE TRIGGER OWNER.TGR_XXX
AFTER
DELETE OR UPDATE
ON OWNER.TABLE
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
DECLARE
cTipo VARCHAR2( 100 );
cHI_USUARIOSIS VARCHAR2( 1500 );
cHI_MAQUINA VARCHAR2( 1500 );
dHI_FECHASIS DATE;
cHI_FECHALOGON VARCHAR2( 1500 );
cHI_PROGRAMA VARCHAR2( 1500 );
PRAGMA AUTONOMOUS_TRANSACTION; <-- You have to add this 1/3
BEGIN

SELECT LOGON_TIME, OSUSER, MACHINE, PROGRAM
INTO cHI_FECHALOGON, cHI_USUARIOSIS , cHI_MAQUINA, cHI_PROGRAMA
FROM V$SESSION WHERE AUDSID = USERENV( 'SESSIONID' ) AND ROWNUM=1;

IF UPDATING THEN
cTipo := 'U';
ELSIF DELETING THEN
cTipo := 'D';
END IF;

INSERT INTO OYM.DSVERSION_ME_RW
HI_USUARIORED ,
HI_USUARIOSIS ,
HI_MAQUINA ,
HI_FECHASIS ,
HI_FECHARED ,
HI_FECHALOGON ,
HI_ACCION ,
HI_PROGRAMA )
SELECT
USER,
CHI_USUARIOSIS ,
CHI_MAQUINA ,
DHI_FECHASIS ,
SYSDATE ,
CHI_FECHALOGON ,
CTIPO,
CHI_PROGRAMA
FROM OWNER.TABLE_2
WHERE FIELD = :OLD.FIELD;
COMMIT; <-- You have to add this 2/3
EXCEPTION WHEN OTHERS THEN
DB_ERR_GRABA ( 0, 'OWNER.TGR_XXX:'||sqlerrm );
ROLLBACK; <-- You have to add this 3/3
END;
/

  ¶ 9:08 AM 0 comments

  The mystery of icon Displacement on Buttons on Oracle Developer for windows (Client/Server) up to Developer 6i (sp18) at least

Several times we had problems displaying icons, we handled several theories, like the cause was the amount of colors, and tried several solutions.
The test was complicated because if you set an icon misplaced and after an icon not misplaced by defaut, it was showed misplace on that button, so you had to reopen the canvas to get refresed.

Recently after a long sequence of test, the mistery was
solved. the problem resides in the name of the icon.
You can do the following test take an icon, and name as a,l,m,s (this words in the icon name causes the displacement) and create another copy naming anything else, but never use that letters, for example 01.
As you can see the same icon is displayed differently depending on the name of the icon, the most interesting was to found different levels of displacement.

Regards,  ¶ 1:03 PM 0 comments