Showing posts with label Database. Show all posts
Showing posts with label Database. 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)