In one of my recent posts I mentioned about Gregory Guillou’s posts about bind variable peeking in 11G. I did a simple test and research on this.
First here is the test case.
YAS@11G>create table t(id number,name varchar2(30));
Table created.
YAS@11G>insert into t select mod(rownum,2),object_name from all_objects;
64901 rows created.
YAS@11G>commit;
Commit complete.
YAS@11G>create index
I have finished my first 11G installation using Vmware Server and Oracle Enterprise Linux 5 and created my first 11G database. The installation is no different than the 10G installation. There are a few differences in the database creation. I have created the database using dbca. When it comes to setting the SGA and PGA sizes it asks if I want to use automatic memory management or not. Using
© 2008 Blog Aggregator - Amardeep Sidhu | Entries (RSS) and Comments (RSS)
Powered by Wordpress, design by Web4 Sudoku, based on Pinkline by GPS Gazette