ADB-Restart

How to quickly restart adb.exe

Step (1). Add this ( or where ever is your “platform-tools” folder located ) path to environment variables path. C:\Users\mm-admin\AppData\Local\Android\sdk\platform-tools Step (2). Open cmd and run these commands : adb kill-server && adb start-server and press enter. This will kill existing broken server running if any, then re-start with the default port assigned. This will Read More

Tuning advisors

How to use SQL Access Advisor?

SQL Access Advisor suggests proper set of materialized views,partitioned tables,indexes for given workload. Complex tasks such as partition of an unpartitioned table needs a go through for access advisors. Here I will suggest how to use access advisor for each component. In case of views, as a virtual table does not hold any data. Every Read More

Pragma14

Autonomous transactions benefits

An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions do SQL operations and commit or Rollback, without committing or rolling back the main transaction. For example, if you write auditing data to a log table, you want to commit the audit data even if the operation you are auditing Read More