Hi friends, What are you thinking about this point? Does database administration becoming more tough nowadays? Some of people replied “no” and some of people replied “yes”. It means, actually we are not understanding my topic accurately. Database administration is becoming tough and in future it will be difficult too. I can prove this thing. [...]
Hi Friends, This is general error getting from Oracle 10g database. It calls as ORA-01045 that lacking of create session privilege. Reason of ORA-01045: From Oracle 10g, connect role doesn’t contain create session privilege. Solution of ORA-01045: If you granted connect role to any user and database was upgraded then you should need to give [...]
Hi friends, Please provide your valuable vote for Oracle support features in following poll. Free Web Polls – Online Polls – Free Online Poll – MicroPoll. Thanks and regards, Remote DBA service Team
Hi frinds, MySQL stores every SQL text and result of same in memory. When identical SQL text executes again that time MySQL retrive data from CACHE and provide output. Indeed memory scan is more faster than disk scan. This CACHE called as QUERY CACHE. For enabling Query Cache in MySQL. Modify my.cnf with following parameters. [...]
Hi friends, So many times we need to check hidden parameters of Oracle. Sometime we forgot script of data dictionary views for writing sql script. Here I am providing you SQL script for check hidden parameters of Oracle. For executing this script you should need to login as SYSDBA. Because only X$ tables are providing [...]
Hi friends, How to set OSAUTH_PREFIX_DOMAIN in Oracle database for windows security of Oracle databases. Yes, we can set OSAUTH_PREFIX_DOMAIN parameter in windows registry as follows. Go to following windows registry of Oracle software HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME# And add entry of OSAUTH_PREFIX_DOMAIN=true This entry forces external user to use domain name in login. After enabling this entry [...]
This is official Blog of Dbametrix Solutions. Dbametrix is group of companies for providing database services and database dba support to global client with exclusive remote support system using strong and transparent SLA and response time matrix with low cost plans.