Showing posts with label System Class. Show all posts
Showing posts with label System Class. Show all posts

Nov 4, 2015

Oracle DB performance

There are few observations on Oracle DB Performance:-

  1. Server Class Installation always faster than Desktop Class
  2. DB perform better in 'AL32UTF8' character set as compare to 'WE8MSWIN1252' (Use this query SELECT * FROM NLS_DATABASE_PARAMETERS and check value against NLS_CHARACTERSET to find out DB character set)