If your operating system is enabled for a single-byte character set, it does not automatically accept double-byte character sets. You must enable your database to store monitoring information that comes in double-byte character strings.
So while creating a database includes the CHARACTER SET UTF8 string. This string enables storage of double-byte character sets.
Enabling the database for double bytes character set is just setting the character set to UTF-8.
To make sure the database is UTF-8 enabled execute the below query.
select value from NLS_DATABASE_PARAMETERS where parameter = 'NLS_CHARACTERSET';
result 1: WE8ISO8859P1
result 2: AL32UTF8
If you get UTF8 then it is UTF-8 enabled
Showing posts with label I know something about ORACLE. Show all posts
Showing posts with label I know something about ORACLE. Show all posts
Thursday, August 9, 2007
Oracle Performance Issue
Using function in the query will get the performance issue (increase the loading time)
lets take a table has got more than 1000 records
example:
SELECT * FROM EMP WHERE UPPER(NAME) = UPPER('ram') takes 15secs
whereas
SELECT * FROM EMP WHERE NAME = 'ram' takes less than a sec
lets take a table has got more than 1000 records
example:
SELECT * FROM EMP WHERE UPPER(NAME) = UPPER('ram') takes 15secs
whereas
SELECT * FROM EMP WHERE NAME = 'ram' takes less than a sec
Subscribe to:
Posts (Atom)