Monday, 28 August 2017

Buy Samsung A9 Pro or C9 Pro

Just to start, both phones are great to hold and look premiuim. I bought A9 pro and  my brother C9 pro, even I wanted to buy C9 pro but decided against it because of 10k difference(A9 Pro better bargain).

Why buy C9 pro?

  • Light weight
  • Looks and feel amazing.
  • Very resposive.
  • 4000mah battery
  • Greatest 6GB RAM.
So, if you can, definitely go for it. Price 31900/- on Amazon at the time of this blog. Luv this phone and highly recommend it.


Why buy A9 Pro? 
  • Battery 5000mah(lasts long time, sometimes 2 days for me)
  • RAM 4GB(would have luv'd 6), good enough.
  • phone feels heavy and sturdy
  • Supports Samsung Pay(Why missing in C9 at this time no idea)

I am a heavy user of phone, mostly data and ton off apps. Not regretting my buy at this time, lets see what the future brings.

Oh yeah waiting for OS upgrade, its still on Android 6.0.1(Marshmallow) as of Aug/28/17.
Upgraded to 7.0, it came over couple of days back, works like charm.(Posted 18/Sept/2017)

Unadvertised feature in both phone:
* Ultra power save mode: In this mode screen swiches to B/W and bare minimum apps, you have choice to include few you need. Phone can last 3x longer duration.
At this time : Charge is 82% claiming life of 29hr, in Ultra save mode it will last 66hrs. Amazing feature, not sure when I would need with 5K battery but gives me lot of confidence to carry this phone on long trips.



Review: JIO vs Airtel vs Vodaphone plans

Specifically related to 349/- or 399/- plans(price differ per vendor)

My choice go for JIO, only jio plan is all inclusive, others don't have SMS/Roaming(Check).

Jio Plans : https://www.jio.com/en-in/4g-plans

Not including SMS, is really hurting, I am on 349/-(Airtel), i have seen my balance going down, because almost every app uses sms for validation and authentication.

Only data and call in a packaged plan, doesn't make sense, package should be all inclusive.

Note: I have multiple connections of Airtel and Jio.

Also see : http://economictimes.indiatimes.com/industry/services/retail/reliance-jio-vs-airtel-vs-vodafone-vs-other-telcos-which-data-plan-you-should-go-for/articleshow/59562800.cms

Wednesday, 9 August 2017

Oracle : Experiment on filesystemio_options

Careful: Results may vary based on configuration options and hardware.

My experiment on a very low power system(laptop):

SQL> alter system set filesystemio_options=asynch scope=spfile;

System altered.

SQL> startup force;
ORACLE instance started.

Total System Global Area 1570009088 bytes
Fixed Size                  2253584 bytes
Variable Size             889195760 bytes
Database Buffers          671088640 bytes
Redo Buffers                7471104 bytes
Database mounted.
Database opened.
SQL>  select status from V$IO_CALIBRATION_STATUS;

STATUS
-------------
IN PROGRESS

------From another session after above change
SET SERVEROUTPUT ON
11:30:51 SQL> DECLARE
lat INTEGER;
iops INTEGER;
mbps INTEGER;
BEGIN
--DBMS_RESOURCE_MANAGER.CALIBRATE_IO(, ,iops, mbps, lat);
DBMS_RESOURCE_MANAGER.CALIBRATE_IO (28, 10, iops, mbps, lat);
DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops);
DBMS_OUTPUT.PUT_LINE ('latency = ' || lat);
DBMS_OUTPUT.PUT_LINE ('max_mbps = ' || mbps);
end;
/11:30:59   2  11:30:59   3  11:30:59   4  11:30:59   5  11:30:59   6  11:30:59   7  11:30:
59   8  11:30:59   9  11:30:59  10  11:30:59  11  11:30:59  12
max_iops = 84
latency = 11
max_mbps = 31

PL/SQL procedure successfully completed.

Elapsed: 00:13:13.69
----------End---------------------------------

SQL> alter system set filesystemio_options=setall scope=spfile;

System altered.

SQL> startup force
ORACLE instance started.

Total System Global Area 1570009088 bytes
Fixed Size                  2253584 bytes
Variable Size             889195760 bytes
Database Buffers          671088640 bytes
Redo Buffers                7471104 bytes
Database mounted.
Database opened.

------From another session after above change
11:46:01 SQL> SET SERVEROUTPUT ON
11:46:11 SQL> DECLARE
lat INTEGER;
iops INTEGER;
mbps INTEGER;
BEGIN
--DBMS_RESOURCE_MANAGER.CALIBRATE_IO(, ,iops, mbps, lat);
DBMS_RESOURCE_MANAGER.CALIBRATE_IO (28, 10, iops, mbps, lat);
DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops);
DBMS_OUTPUT.PUT_LINE ('latency = ' || lat);
DBMS_OUTPUT.PUT_LINE ('max_mbps = ' || mbps);
end;
/11:46:21   2  11:46:21   3  11:46:21   4  11:46:21   5  11:46:21   6  11:46:21   7  11:46:
21   8  11:46:21   9  11:46:21  10  11:46:21  11  11:46:21  12
max_iops = 47
latency = 20
max_mbps = 37

PL/SQL procedure successfully completed.

Elapsed: 00:10:39.87
----------End---------------------------------
SQL> alter system set filesystemio_options=directIO scope=spfile;

System altered.

SQL> startup force
ORACLE instance started.

Total System Global Area 1570009088 bytes
Fixed Size                  2253584 bytes
Variable Size             889195760 bytes
Database Buffers          671088640 bytes
Redo Buffers                7471104 bytes
Database mounted.
Database opened.
SQL>
------From another session after above change
12:02:18 SQL> SET SERVEROUTPUT ON
12:02:22 SQL> DECLARE
lat INTEGER;
iops INTEGER;
mbps INTEGER;
BEGIN
--DBMS_RESOURCE_MANAGER.CALIBRATE_IO(, ,iops, mbps, lat);
DBMS_RESOURCE_MANAGER.CALIBRATE_IO (28, 10, iops, mbps, lat);
DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops);
DBMS_OUTPUT.PUT_LINE ('latency = ' || lat);
DBMS_OUTPUT.PUT_LINE ('max_mbps = ' || mbps);
end;
/12:02:35   2  12:02:35   3  12:02:35   4  12:02:35   5  12:02:35   6  12:02:35   7  12:02:35   8  12:02:35   9  12:02:35  10  12:02:35  11  12:02:35  12
max_iops = 57
latency = 16
max_mbps = 12

PL/SQL procedure successfully completed.

Elapsed: 00:12:10.24
----------End---------------------------------

Let me know if u don't agree with method or anything else.
Still wip.