No question at this time
DBA Top 10
1 M. Cadot 20600
2 A. Kavsek 14800
3 M. Hidayathullah ... 10500
4 B. Vroman 8100
5 P. Wisse 5300
6 T. Boles 4200
7 J. Schnackenberg 3800
8 K. Van Nieuwenhov... 2100
9 G. Van Cauter 1400
10 K. Pagadala 1100
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 users48057
Total active users1738
Act. users last 24h12
Act. users last hour0
Registered user hits last week391
Registered user hits last month1277
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, 250 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, 249 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, 249 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, 238 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