No question at this time
DBA Top 10
1 M. Cadot 22600
2 A. Kavsek 15200
3 M. Hidayathullah ... 11000
4 B. Vroman 8100
5 P. Wisse 6000
6 T. Boles 5200
7 J. Schnackenberg 3300
8 G. Lambregts 2200
8 P. Knibbs 2200
8 K. Pagadala 2200
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 users48017
Total active users1850
Act. users last 24h5
Act. users last hour0
Registered user hits last week339
Registered user hits last month1183
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, 190 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, 189 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, 188 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, 177 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