No question at this time
DBA Top 10
1 M. Cadot 17000
2 A. Kavsek 14300
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4900
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
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 users48097
Total active users1702
Act. users last 24h1
Act. users last hour0
Registered user hits last week237
Registered user hits last month1339
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...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts 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
Ales, This article informed me about the <i>app...... Guy Lambregts Feb 23, 2017, 11:19

Follow up by mail Click here


Subject: Oracle 12.1.0.2 inmemory option
Author: Peter Smeets, Belgium
Date: Feb 10, 2017, 16:49, 310 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, 308 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
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, 308 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

Subject: Re: Oracle 12.1.0.2 inmemory option
Author: Guy Lambregts, Belgium
Date: Feb 23, 2017, 11:19, 297 days ago
Message: Ales,

This article informed me about the approx_count_distinct operator, never heard about it.

Thanks

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