Tag: remote dba

Database Administration is becoming tough

Database Administration is becoming tough

January 4, 2012 | By | Add a Comment

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. […]

Read More

ORA-01045: user SCOTT lacks CREATE SESSION privilege

ORA-01045: user SCOTT lacks CREATE SESSION privilege

November 7, 2010 | By | Add a Comment

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 […]

Read More

Free Web Polls – Online Polls – Free Online Poll – MicroPoll for Oracle support

Free Web Polls – Online Polls – Free Online Poll – MicroPoll for Oracle support

October 29, 2010 | By | Add a Comment

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

Read More

Query Cache in MySQL

Query Cache in MySQL

October 5, 2010 | By | Add a Comment

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. […]

Read More

Hidden parameter checking script for Oracle

Hidden parameter checking script for Oracle

October 1, 2010 | By | Add a Comment

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 […]

Read More

OSAUTH_PREFIX_DOMAIN for Oracle

OSAUTH_PREFIX_DOMAIN for Oracle

February 8, 2010 | By | Add a Comment

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 […]

Read More