H.Tonguç YILMAZ Blog

This paper summaries the five oracle editions, the advanced options and the management pack of Oracle;
The editions:
Standard Edition One,Standard edition, Entreprise Edition, Personal Edition, Express Editions
The options:
RAC, Partitioning, Advanced Security, Label Security, OLAP, Data Mining, Spatial
The management packs:
Change management, Diagnostic, Tuning and Configuration Management Packs

Here is the full story of the RADRace

And the OTN Resources on Oracle Application Development Framework

Oracle ADF is an end-to-end J2EE framework that simplifies development by providing out of the box infrastructure services and a visual and declarative development experience.

Patrick has a blog on ApEX, one of my favorites. Today I saw his post on the error page problem. The post consists two demo applications and the sources, as always, to clarify the solution. Great work, thank you Patrick check the solution -> Hacking the APEX error page!
Don’t forget to check out his ApexLib framework solutions!

Some integrated development environments (IDE) are more integrated than others. Oracle JDeveloper is much more than a Java programming tool. Integrated into its core Java IDE are a host of other IDEs such as:

XML development – visual editors for XSD, XSLT, XQuery, WSDL, and support for debugging XSLT
Web development – visual editors for CSS, as well as WYSIWYG editors for HTML, JSP, JSF (pages and config) and ADF Faces (a k a Apache MyFaces Trinidad), Struts (config) and Applets and an HTTP Analyzer for analysis of the packets sent across the wire for Web Services and Web applications
J2EE development – wizards for EJB, Web Services, and the built-in OC4J Application Server to deploy J2EE artifacts quickly, as well as very easy remote debugging of both Web and J2EE applications. JDeveloper also provides an IDE for Oracle TopLink – one of the premium tools for object-relational mapping
Database development – editors and diagrammers for tables, database browsers, SQL worksheets, data viewer for all JDBC-powered databases as well as programming and debugging support for PL/SQL – the Oracle database’s stored procedural language
UML modeling – diagrammers for activity, class (with code synchronization), sequence and use case diagrams
Integration – visual modeling, testing. and deploying Web Services, BPEL processes, and ESB services

If you haven’t looked at Oracle JDeveloper in a while, you’ll definitely want to take a second look now. Installation only takes unzipping an archive. Oracle JDeveloper 10.1.3.1 is free and available for download at: http://oracle.com/technology/jdev

Reference

http://java.sys-con.com/read/313602.htm

Oracle JDeveloper 10.1.3.1.0 Feature Matrixhttp://www.oracle.com/technology/products/jdev/101/collateral/101/featurematrix_10131.html

One of my colegues asked this, if you run this with sys at XE;

begin
DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
COMMIT ;
end;

it is done to check the ip and port status netstat from command prompt can be used, initially;

D:\>netstat -an

Active Connections

Proto  Local Address          Foreign Address        State
..
TCP    127.0.0.1:8080         0.0.0.0:0              LISTENING
..

Then

..
TCP    0.0.0.0:8080           0.0.0.0:0              LISTENING
..

Or instead of SQL you can use XE administration frontend as mentioned in the below documentation to change this http setting.

References
Oracle® Database Express Edition Installation Guide

http://www.oracle.com/technology/software/products/database/xe/files/install.102/b25144/toc.htm

OTN Discussion Forums » Oracle Database XE » Oracle Database 10g Express Edition

http://forums.oracle.com/forums/forum.jspa?forumID=251&start=0

OTN Discussion Forums » Database » Application Express

http://forums.oracle.com/forums/forum.jspa?forumID=137

This is a demostration of what is mentioned on this post of Mr.Lewis; http://jonathanlewis.wordpress.com/2006/12/11/cost-is-time/
First you must start using system statistics as mentioned in my previous post.

SELECT pname, pval1 FROM sys.aux_stats$ WHERE sname = ‘SYSSTATS_MAIN’;

PNAME PVAL1
—————————— ———-
CPUSPEEDNW 491,366552
IOSEEKTIM 10
IOTFRSPEED 4096
SREADTIM 10,204
MREADTIM 12,883
CPUSPEED 236
MBRC 28
MAXTHR 6822912
SLAVETHR

9 rows selected.

execute dbms_random.seed(0)

drop table t1 purge;
create table t1 as select
rownum id,
trunc(dbms_random.value(1,50)) n1,
rpad(’x’,100) padding
from dba_source ;
create unique index ui_t1_id on t1(id);

exec dbms_stats.gather_table_stats(user,tabname =>’T1′,cascade => true,estimate_percent => null,granularity => ‘default’,method_opt => ‘for all columns size 1′ );

alter system flush shared_pool ;

explain plan set statement_id ‘xyz’ for select n1, padding from t1 where id > 100;

select * from table(dbms_xplan.display(’plan_table’,’xyz’));

————————————————————————–
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
————————————————————————–
| 0 | SELECT STATEMENT | | 154K| 15M| 137 (17)| 00:00:02 |
|* 1 | TABLE ACCESS FULL| T1 | 154K| 15M| 137 (17)| 00:00:02 |
————————————————————————–

cost : 137
SREADTIM : 10.204
time : 2

in the post time is mentioned to be calculated as -> round(cost * SREADTIM / 1000, 3) and ;

select round(137 * 10.204 / 1000, 3) time from dual ;

TIME
———-
1,398

Mr.Lewis explains this difference between 2 and 1,398 as; “Oracle got as close as it could because it’s reporting to the second – and it’s rounding up, rather than rounding to the nearest second.”

References

http://tonguc.oracleturk.org/index.php?s=cost+estimated+time

Following tests were made on Oracle XE;

– connect with SYS in this first session and start gathering
– initially system statistics are not available
SELECT pname, pval1 FROM sys.aux_stats$ WHERE sname = ‘SYSSTATS_MAIN’;

PNAME                               PVAL1
—————————— ———-
CPUSPEED
CPUSPEEDNW                        495,977
IOSEEKTIM                              10
IOTFRSPEED                           4096
MAXTHR
MBRC
MREADTIM
SLAVETHR
SREADTIM

9 rows selected.

SELECT TO_CHAR(sysdate,’DD-MON-YY HH24:MI:SS’) “Stop” FROM dual;
exec dbms_stats.gather_system_stats(’start’);
–
– in this period we will create some load from another HR session
–
– may use this to sleep this session for 3 minutes
– exec dbms_lock.sleep(180);
–
– connect with HR in this second session
– to simulate an olap load
create table tab_stress_me nologging parallel 2 as
select * from dba_source order by 1,2,3;
EXEC DBMS_STATS.gather_table_stats(user, ‘tab_stress_me’, estimate_percent => 50, block_sample => FALSE, degree => 2, granularity => ‘ALL’, cascade => TRUE) ;
commit;
drop table tab_stress_me purge;
execute dbms_random.seed(0)
create table t1 nologging parallel 2 as select
rownum                id,
trunc(dbms_random.value(1,50))    n1,
rpad(‘x’,100)            padding
from    dba_source ;
create unique index pk_t1_id on t1(id) nologging parallel 2;
EXEC DBMS_STATS.gather_table_stats(user, ‘t1′, estimate_percent => 50, block_sample => FALSE, degree => 2, granularity => ‘ALL’, cascade => TRUE) ;
commit;
–
– to simulate an oltp load
BEGIN
FOR i IN 1 .. 1000 LOOP
FOR c IN (select n1, padding from t1 where id = i) LOOP
NULL;
END LOOP;
END LOOP;
END;
/
drop table t1 purge;
–
– return to the session connected with SYS and stop gathering
exec dbms_stats.gather_system_stats(’stop’);
SELECT TO_CHAR(sysdate,’DD-MON-YY HH24:MI:SS’) “Stop” FROM dual;
commit;
–
– system statistics are now available
SELECT pname, pval1 FROM sys.aux_stats$ WHERE sname = ‘SYSSTATS_MAIN’;

PNAME                               PVAL1
—————————— ———-
CPUSPEED                              496
CPUSPEEDNW                        495,977
IOSEEKTIM                              10
IOTFRSPEED                           4096
MAXTHR                            7029760
MBRC                                   88
MREADTIM                           26,065
SLAVETHR
SREADTIM                              4,8

9 rows selected.

References

Understanding System Statistics by Jonathan Lewis

http://www.oracle.com/technology/pub/articles/lewis_cbo.html

AskTom “CPU costing, mreadtim < sreadtim”

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:67994814192949

Oracle® Database Performance Tuning Guide 10g Release 2 (10.2) – 14.4 System Statistics

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14211/stats.htm#sthref1468

Playing With System Statistics

http://oraclesponge.blogspot.com/2005/12/playing-with-system-statistics.html