Database Administrator

set heading off verify off feedback off echo off term off linesize 200 wrap on spool c:\temp\Recreate_Users.sql SELECT distinct 'create ...

spool c:\usercreation.sql set pages 0 feed off veri off lines 500 accept oldname prompt "Enter user to model new user to: " accept...

------Drive Share Script------ net share E=e: /unlimited /GRANT:everyone,FULL exit ------remove Drive Share Script---------- net share D /de...

set heading off verify off feedback off echo off term off linesize 200 wrap on spool c:\password_users.sql SELECT 'alter user ' || u...

Oracle 10g Standby Database -------------------------------------- PRODUCTION DATABASE: 10.100.0.65 STANDBY DATABASE: 10.100.0.32 ----------...

SQL Performance Tuning 1. Use EXPLAIN to profile the query execution plan 2. Use Slow Query Log (always have it on!) 3. Don't us...

Stored Outlines Oracle preserves the execution plans in objects called “Stored Outlines.” You can create a Stored Outline for one or more SQ...

Prerequisites SQL> @ORACLE_HOME\rdbms\admin\utlxplan.sql This creates the PLAN_TABLE for the user executing the script. ---------- Settin...

Cost Based Optimizer (CBO) and Database Statistics The mechanisms and issues relating to maintenance of internal statistics are explained be...

SQL> @ORACLE_HOME\rdbms\admin\utlxplan.sql This creates the PLAN_TABLE for the user executing the script. Run EXPLAIN PLAN for the query ...

check in Control Panel ->Administrative -> ODBC Manager -> Tracing(tab) -> click on Stop Tracing Always remember to stop it Note...

To start a SQL trace for the current session, execute: ALTER SESSION SET sql_trace = true; ALTER SESSION SET sql_trace = true; or DBMS_SYSTE...

mkdir c:\backupfolders\%date:~0,2% mkdir c:\backupfolders\%date:~3,2% mkdir c:\backupfolders\%date:~6,4% mkdir c:\backupfolders\%date:~8,2% ...

cat /etc/tcp.smtp login as: root root@10.100.0.77's password: Last login: Wed Jul 14 16:28:50 2010 from 172.16.203.28 [root@mail ~]# cd ...

multiple domains point to the one URL redirect all your secondary domain names to your primary domain name is to do it at your domain name r...

Today Google Webmaster team has roll out new Webmaster Tool Interface for all. From today onwards when you login to Google Webmasters you wi...

------------- ---------------------------------------------------- ----------------------

Headings Tag in HTML: Headings are defined with the to tags. defines the largest heading and used for main heading , , , , define...

SELECT SUBSTR(sql_text, INSTR(sql_text,'INTO "'),30) table_name , rows_processed , ROUND( (sysdate-TO_DATE(first_load_time,...

select segment_name table_name, sum(bytes)/(1024*1024) table_size_meg from user_extents where segment_type='TABLE' an...