Friday, January 22, 2016

Looking for in Android Custom ROM

CAF
?control of brightness from header
soft reboot
Lockscreen weather
Clock widget
?V4A
Gestures
Recents panel

Saturday, December 19, 2015

Sunday, November 29, 2015

Twitter Error

Wednesday, November 18, 2015

Estimate size of tables in Oracle


dba_segments gives better estimate than user_segments but you may not have access to dba_segments view

SELECT segment_name, segment_type, bytes/1024/1024 MB
FROM user_segments
WHERE segment_name like 'PREFIX_%';


Following query provides number of rows and columns too

SELECT col.table_name,  col.col_cnt  AS column_count,  rc.row_cnt   AS row_count,  s.size_in_MB AS table_size_in_MB
FROM  (
  /* number of columns */  SELECT upper(table_name) table_name,    COUNT(*) col_cnt
  FROM user_tab_columns /* you can change it to dba_tab_columns */  --WHERE owner = 'OWNER' /* uncomment if you are using dba_tab_columns object*/  WHERE table_name like 'PREFIX_%'  GROUP BY upper(table_name)
  ) col
JOIN  (
  /* number of rows */  SELECT table_name,    to_number(extractvalue(xmltype(dbms_xmlgen.getxml('select count(*) c from '    ||table_name)),'/ROWSET/ROW/C')) AS row_cnt
  FROM user_tables  /* you can change it to dba_tables */  WHERE (iot_type != 'IOT_OVERFLOW'  OR iot_type     IS NULL)
 -- AND owner        = 'OWNER' /* uncomment if you are using dba_tables object */
  AND  table_name like 'PREFIX_%'
  ) rc
ON upper(col.table_name) = upper(rc.table_name)
JOIN  (
  /* table size in MB */  SELECT    --owner,    table_name,    (SUM(bytes)/1024/1024) size_in_MB
  FROM    (SELECT segment_name table_name,      bytes
    FROM user_segments  /* you can change it to dba_segments */    WHERE segment_type = 'TABLE'      --and owner = 'OWNER' /* uncomment if you are using dba_segments object */
    AND segment_name like 'PREFIX_%'
    )
  GROUP BY --owner,    table_name  ) s
ON upper(col.table_name) = upper(s.table_name);

Sunday, October 18, 2015

One Plus One (bacon) GPS fix

1. Backup /system/etc/gps.conf

2. Copy this file to /system/etc/gps.conf 
This enables AGPS and SGLTE


####################################
#  LTE Positioning Profile Settings
####################################
# 0: Enable RRLP on LTE(Default)
# 1: Enable LPP_User_Plane on LTE
# 2: Enable LPP_Control_Plane
# 3: Enable both LPP_User_Plane and LPP_Control_Plane
LPP_PROFILE = 3

################################
# EXTRA SETTINGS
################################
# NMEA provider (1=Modem Processor, 0=Application Processor)
NMEA_PROVIDER=0
# Mark if it is a SGLTE target (1=SGLTE, 0=nonSGLTE)
SGLTE_TARGET=1


3. Get the nearest NTP server from here : http://www.pool.ntp.org/en/ and update it in your gps.conf

4. change permissions of /system/etc/gps.conf to RW-R--R-- (644)

5. Use GPS Status Test & Fix app to reset & download AGPS data : https://play.google.com/store/apps/details?id=com.cochibo.gpsstatus&hl=en

6. I changed 'Tmobile US LTE' APN type from default,supl,mms to
default,supl,mms,agps. For your provider the settings may be different

7. Reboot and toggle Location to "High Accuracy"

PS: If you install Greenify, Amplify profile, custom kernel, disable service, wakelock fix, underclocking, build.prop flashable zip from here location services get disabled and the fix does not work 

Wednesday, September 30, 2015

One Plus One (bacon) increase volume MOD - Low Volume fix

1. To increase volume of One Plus One copy this file to /system/etc/mixer_paths.xml and override the existing file and change permissions to RW-R--R-- (644)



If you search the file value="93" is where the values were increased.

2. Fix for low mic on call
REF: http://forum.xda-developers.com/oneplus-one/development/fix-low-mic-call-t3055661

EDIT: /system/build.prop and update the following values:
BEFORE FIX
ro.qc.sdk.audio.fluencetype=fluence
persist.audio.fluence.voicecall=true

AFTER FIX
ro.qc.sdk.audio.fluencetype=fluence
persist.audio.fluence.voicecall=true
persist.audio.fluence.voicerec=false
persist.audio.fluence.speaker=false


LowMicFix.zip and LowMicFix.prop should be in the same directory when flashing 

Saturday, September 05, 2015

GApps default apps removal script

https://drive.google.com/file/d/0Bxcg1P5wULMhTFRFS284ZGU0UUE/view?usp=sharing