No question at this time
DBA Top 10
1 M. Cadot 28300
2 A. Kavsek 15700
3 B. Vroman 12300
4 M. Hidayathullah ... 11100
5 F. Diaz 9300
6 T. Boles 8800
7 P. Wisse 7700
8 J. Schnackenberg 6600
9 A. Hudspith 6300
10 P. Knibbs 2500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users47871
Total active users1976
Act. users last 24h3
Act. users last hour0
Registered user hits last week345
Registered user hits last month2131
Go up

Oracle 12.1.0.2 inmemory option
Next thread: Creating 12c AUDIT PROFILES from standard audit setups
Prev thread: gcc version for Oracle 11.2.0.4 on Linux 7

Message Score Author Date
Hello, Performance of a query remains the same ...... Peter Smeets Feb 10, 2017, 16:49
Hi Peter, https://blogs.oracle.com/In-Memory/en...... Ales Kavsek Feb 11, 2017, 18:21
Dear, Please check this link once. https:/...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Mirza Hidayathullah Baig Feb 12, 2017, 07:26

Follow up by mail Click here


Subject: Oracle 12.1.0.2 inmemory option
Author: Peter Smeets, Belgium
Date: Feb 10, 2017, 16:49, 9 days ago
Os info: Micorsoft Windows 64bit
Oracle info: 12.1.0.2 Enterprise edition
Message: Hello,

Performance of a query remains the same with or without using inmemory option?!

Compatible parameter is set to 12.1.0.2.0.
inmemory_size is set to 1G.
optimizer_features_enable is set to 12.1.0.2.
optimizer_inmemory_aware is set to TRUE;
alter session set inmemory_query=ENABLE;

Alter table AMDELCSS inmemory PRIORITY High;

SELECT count(distinct a.deliverycustomer) FROM amdelcss a
WHERE a.company = 1
and a.deliveryreturn = 1
and a.deliverycustomer > 600 and a.deliverycustomer < 12600
AND a.price > 1
GROUP BY a.deliverycustomer;

Explain plan shows table access inmemory FULL for the above sql.

Still, performance remains the same...

I really appreciate all suggestions!
Tx, Peter
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle 12.1.0.2 inmemory option
Author: Ales Kavsek, Slovenia
Date: Feb 11, 2017, 18:21, 8 days ago
Message: Hi Peter,

https://blogs.oracle.com/In-Memory/entry/why_didn_t_database_in

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle 12.1.0.2 inmemory option
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Feb 12, 2017, 07:26, 7 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Dear,


Please check this link once.

https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=443969.1%3AE52281_01&action=inline

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here