Saturday, April 02, 2011

Oracle Database 11g Express Edition (11.2) Beta

Thank you Tanel Poder'blog and Kris's blog for sharing about Oracle Database 11g Express Edition (11.2) Beta. We can download for Beta.
We will see version for Windows x32 and Linux x64. However I was curious for testing, and I have only Windows 7 (64 bits). OK... try to install and It's work. Great!!!
***I don't want to explain How to install, just show some pages***
After installed, we will see menu for "Oracle Database 11g XE" by clicking "Start" -> "All Programs"... and...
In menu, we can choose "Run SQL Command Line" and then...

In menu, If we choose "Get Started", we will see this page.
and check on each of menu.
How about memory parameters?
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big integer 0

SQL> show parameter memory_target

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_target big integer 0

SQL> show parameter sga_max_size

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 768M

SQL> show parameter sga_target

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_target big integer 768M

SQL> show parameter pga_aggregate_target

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 256M

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_buffer integer 5009408
We can check Online Documentation and Database 11g Express Edition Forum.
However, I hope to hear some idea and... after you test it -)

***In case: We installed XE 32bits in Windows 64bits. So We will see this error:
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !
OER 7451 in Load Indicator : Error Code = OSD-04500: illegal option specified
O/S-Error: (OS 1) Incorrect function. !

However, I just want to test... for XE 11gR2

No comments: