Google DNS or Open DNS etc.

Use any Google or open dns.

Google DNS

Preferred: 8.8.8.8
Alternate: 8.8.4.4

OpenDNS

Preferred: 208.67.222.222
Alternate: 208.67.220.220

How to use:

1. Modify dns in your router normally would be found under internet or wan setup.

2. Modify in your local machine network, see images below for reference.

Google DNS

Preferred: 8.8.8.8
Alternate: 8.8.4.4

OpenDNS

Preferred: 208.67.222.222
Alternate: 208.67.220.220

For my reference:

Spectra DNS:

180.151.151.151

180.151.151.152

Review: Amazon Fire TV stick after few days of use

Overall: Amazing product

Bought amazon fire tv stick, got delivery ahead of time, big KUDO's to Amazon folks.

Setup is very simple, detects available wifi's, just enter the pass code and device is ready to go. Amazon prime could be used right away(subscription required). As for other apps like times now, netflix, jio cinema etc, appear as shortcuts and one needs to click and install.

As for performance, prime content plays flawlessly, you can watch all the hosted content in all its glory right away.  Same could not be said for other apps as they depend on external vendors. Eg: Times of india app plays with a lag and lot of pixelation, good thing is gets sharp pretty quickly. No complaints there.


Pros:
* Easy setup
*Ton of content
*Quality of display amazing.


Cons:
* No mouse pointer, primitive point & click design.
* Browser(web), could not find...still trying. Prefer,should there by default.
* Mouse is clicker type, would prefer a more modern point and click.

If you don't have a smart TV, this is a very cool device to have, overwhelming amount of content. Personally very happy with the purchase. I would prefer cost be reduced if content inside is all subscription based. Also have comprehensive TV app something like JIO TV, would make this device even more appealing.

Oracle : Experiment on basic compression on table data

---------Exp start

SQL> select count(1) from scott.xemp;

  COUNT(1)

----------

  14680064

select table_name,COMPRESSION,COMPRESS_FOR from dba_tables where table_name='XEMP';

TABLE_NAME                     COMPRESS COMPRESS_FOR

------------------------------ -------- ------------

XEMP                           DISABLED

SQL> select sum(bytes)/power(1024,2) from dba_segments where segment_name='XEMP';

SUM(BYTES)/POWER(1024,2)

------------------------

                     704

SQL> alter table scott.xemp move compress;

Table altered.

SQL> select sum(bytes)/power(1024,2) from dba_segments where segment_name='XEMP';

SUM(BYTES)/POWER(1024,2)

------------------------

                     176

SQL>  select table_name,COMPRESSION,COMPRESS_FOR from dba_tables where table_name='XEMP';

TABLE_NAME                     COMPRESS COMPRESS_FOR

------------------------------ -------- ------------

XEMP                           ENABLED  BASIC

---------Exp END

Basic compression is free(double check). 

For experiment, table was freshly created with no deletes on the table(i.e. compact). Looks like compression gave about 75% reduction in size. 

This reduces the logical foot print of the table and one may be able to reclaim some space, reduction of file size  is another issue, we may be able to release some space there too(subject to hit and try method).