tag:blogger.com,1999:blog-80155358483096039542012-02-12T14:22:18.876-08:00The Moto behind for Creating this Blog is to share the concepts Of Oracle Database.In This Blog,The Information is gathered from Metalink,Expert's Blog and Oracle Documentaion.It Includes Real Time Scenarios,Oracle9i concepts,Oracle10g Concepts,RAC,Streams,Replication... Please do visit my blog and post your comments & advice please.ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.comBlogger1681100tag:blogger.com,1999:blog-8015535848309603954.post-34302593530760395312011-09-07T08:22:00.000-07:002012-02-02T08:11:46.171-08:00

srvctl enable asm -n node_name [-i ] asm_instance_nameUse the following syntax to disable an ASM instance:srvctl disable asm -n node_name [-i asm_instance_name]The above statement is generally required when u want to disable the asm so that asm does not start automatically on reboot.You can also use SRVCTL to start, stop, and obtain the status of an ASM instance as in the following examples.Use

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-35895011460817735692011-07-31T08:12:00.000-07:002011-07-31T08:14:03.913-07:00

$ORA_CRS_HOME/crs/log--->contains trace files for the CRS resources$ORA_CRS_HOME/crs/init--->contains the trace files of the CRS daemon during startup.Good Place to start with any CRS login problems.$ORA_CRS_HOME/css/log---->The Cluster Synchronization (CSS) logs indicate all actions sych as reconfigurations,missed check -inbs,connects and disconnects from the client CSS listener.In some cases,

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com3tag:blogger.com,1999:blog-8015535848309603954.post-36868006888704595762011-05-15T20:53:00.000-07:002011-05-16T22:52:04.651-07:00

Possibility1:Planned Fail overNote:Primary Database will be down until DR Test completesa.Take cold/hot/RMAN backup on primary before DR test b.Take cold/hot/RMAN backup on standby Database before DR test. c.Shutdown Primary Databased.On standby Database fire the below command sql> alter database activate standby database;e.Once standby Database is activated,Execute the below command. sql >

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-11599609022206447322008-01-23T23:25:00.000-08:002012-02-02T08:14:19.140-08:00

Architecture Database Synchronization Options Setup No-Data-Divergence Setup Primary Database Setup Standby Database Start Managed Standby Recovery Protect Primary Database Cancel Managed Standby Recovery Activating A Standby Database Backup Standby Database Database Switchover Database Failover Automatic Archive Gap Detection Background Managed Recovery Delayed Redo

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com275tag:blogger.com,1999:blog-8015535848309603954.post-77316272441467555902008-01-22T19:28:00.000-08:002008-01-22T19:30:17.008-08:00

Syntax LOG_ARCHIVE_DEST_[1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10] = "null_string" | ((SERVICE=service | LOCATION=location) [AFFIRM | NOAFFIRM] [ALTERNATE=destination | NOALTERNATE] [ARCH | LGWR] [DELAY[=minutes] | NODELAY] [DEPENDENCY=destination | NODEPENDENCY] [MANDATORY | OPTIONAL] [MAX_FAILURE=count | NOMAX_FAILURE] [QUOTA_SIZE=blocks | NOQUOTA_SIZE] [QUOTA_USED=blocks | NOQUOTA_USED] [

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-28597216850724564642008-01-22T19:23:00.000-08:002008-01-22T19:25:22.305-08:00

PURPOSE-------This article gives an overview about how to create a Data Guard Configuration on Real Application Clusters (RAC). The Configurationyou can find here is for a Physical Standby Database. SCOPE & APPLICATION-------------------You can see which initialisation parameters you have to use / changeand how the Log Transport is organized in a RAC-DataGuard environment. NOTE: The Data Guard

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-37263599215473006522008-01-22T19:14:00.000-08:002008-01-22T19:15:27.494-08:00

1) Ensure the Primary database is in ARCHIVELOG mode: SQL> archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination /export/home/oracle/temp/oracle/arch Oldest online log sequence 7 Current log sequence 9 SQL> alter database close; Database altered. SQL> alter database archivelog; Database

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com13tag:blogger.com,1999:blog-8015535848309603954.post-39390316968858937432008-01-20T18:34:00.001-08:002012-02-09T08:33:38.603-08:00

1.Regular Monitoring of The free space in Database. 2.Taking logical bakups of important table. 3.Checking the locks on the Database. 4.Checking the long running queries on ur database 5.Analysing the performance of ur Database 6.Investigate Wait Statistics 7.Tablespace Usage 8.Ensure Connectivity to Oracle 9.Lock Contention 10.Extent Failure 11.Alert Logs

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-7948888834897074662008-01-20T18:34:00.000-08:002011-05-17T00:08:22.090-07:00

1.Regular Monitoring of The free space in Database.2.Taking logical bakups of important table.3.Checking the locks on the Database.4.Checking the long running queries on ur database5.Analysing the performance of ur Database6.Investigate Wait Statistics 7.Tablespace Usage 8.Ensure Connectivity to Oracle 9.Lock Contention 10.Extent Failure 11.Alert Logs 12.Redo Logs 13.Check if all the instances

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-42148750912456653812008-01-10T02:18:00.000-08:002012-02-09T08:35:32.491-08:00

1. Create a Table By the Name db_growth...with following details... Name Null? Type ----------------------------------------- -------- ---------------------------- DAY DATE DATABASE_SIZE_MB NUMBER DAILY_GROWTH_MB

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com8tag:blogger.com,1999:blog-8015535848309603954.post-34065541268923010932008-01-09T04:20:00.001-08:002008-01-09T05:42:59.261-08:00

IntroductionThis article will introduce the reader to the basics of auditing an Oracle database. Oracle's RDBMS is a functionally rich product and there are a number of auditing alternatives available to the reader. Because auditing Oracle is such a huge subject, doing all of it justice would take an entire book, so this paper will cover the basics of why, when and how to conduct an audit. It

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-10575904582516118502008-01-08T04:06:00.000-08:002012-02-09T08:42:43.413-08:00

I. Display the Current Archivelog Status :ARCHIVE LOG LIST;II. Creating a Control File Trace FileALTER DATABASE BACKUP CONTROLFILE TO TRACE;III. Tablespace Free Extents and Free Spacecolumn Tablespace_Name format A20column Pct_Free format 999.99select Tablespace_Name,Max_Blocks,Count_Blocks,Sum_Free_Blocks,100*Sum_Free_Blocks/Sum_Alloc_Blocks AS Pct_Free from(select Tablespace_Name, SUM(Blocks)

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-17489448403319623692007-12-24T03:13:00.000-08:002007-12-24T03:14:27.939-08:00

STEPS for creating 10g dataguardprerequisite : 9i dataguard setup knowledgestep1 :Prepare initSID.ora file for primary and standby databases as follow.** STANDBY setup parameters are given in BOLDpart A)**** Production database primary file ****prod.__db_cache_size=125829120prod.__java_pool_size=4194304prod.__large_pool_size=4194304prod.__shared_pool_size=79691776prod.__streams_pool_size=0*.

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com29tag:blogger.com,1999:blog-8015535848309603954.post-33160770605315019572007-12-24T03:08:00.000-08:002007-12-24T03:10:01.800-08:00

SQL> EXEC DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL('TEMPD')BEGIN DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL('TEMPD'); END;*ERROR at line 1:ORA-03245: Tablespace has to be dictionary managed, online and permanent to be able to migrateORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 0ORA-06512: at line 1SQL> EXEC DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL('USERSD')PL/SQL procedure successfully

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com3tag:blogger.com,1999:blog-8015535848309603954.post-47939715849459005412007-12-24T03:04:00.000-08:002007-12-24T03:05:54.087-08:00

9/10g install on Linux/Solaris Install Oracle 9i Database on Linux RHEL AS 3the following lines can be added to the /etc/sysctl.conf file:kernel.shmmax = 2147483648kernel.shmmni = 128kernel.shmall = 2097152kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000In addition the following lines can be added to the /etc/security/limits.conf file:oracle soft nofile

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com5tag:blogger.com,1999:blog-8015535848309603954.post-22273079202219945602007-12-24T03:00:00.000-08:002007-12-24T03:01:11.168-08:00

select * from v$transaction;--All tranasactions + sid and usernameselect s.sid,s.username, t.start_time, t.used_ublk, t.used_urecfrom v$transaction t, v$session swhere t.ses_addr=s.saddr;--All tranasactions + sid and username + first 64 bytes of SQLselect s.sid,s.username, t.start_time, t.used_ublk, t.used_urec,sql.sql_textfrom v$transaction t, v$session s, v$sql sqlwhere t.ses_addr=s.saddrand

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-79810820546840110862007-12-24T02:58:00.000-08:002007-12-24T02:59:54.683-08:00

Give more knowledge to cost based optimizer about object statisticsand make it intelligent.. U remember Knowledge is Power - Aristotle-- Gather stats for a table. Auto sampling and auto number of histogram -- buckets, might not work in previous Oracle version.begindbms_stats.gather_table_stats('&OWNER','&TABLE_NAME',null,DBMS_STATS.AUTO_SAMPLE_SIZE -- put null or percentage for older oracle,false

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-84944722446288951602007-12-24T02:56:00.000-08:002007-12-24T02:58:32.434-08:00

What is Right What is Wrong Found a DBA giving following commands at standby site to switchover while standby database was mounted.SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY*ERROR at line 1:ORA-16139: media recovery requiredSQL> recover managed standby database disconnect;Media recovery complete.SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-79166161183406986822007-12-24T02:55:00.000-08:002007-12-24T02:56:24.670-08:00

Database creation in RAC environment( 2 instances). can not rely on dbca always CREATE PARAMETER FILE AND PLACE IT IN SHARED LOCATION (O:\TEST\INITTEST.ORA shared location here ) AS FOLLOWING SO THAT BOTH RAC INSTANCES CAN SHARE IT. point to this pfile/spfile from individual instance home/dbs. # START OF INITTEST.ORA *.aq_tm_processes=1*.test1.background_dump_dest='D:\Oracle\admin\test1\bdump'*.

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-36506071071418556122007-12-24T02:24:00.000-08:002007-12-24T02:25:41.644-08:00

traditional method before 10gselect * from v$sql where address='&ADDRESS' and hash_value=&HASH_VALUE;10g select * from v$sql where sql_id='&SQL_ID';select * from v$sqlstats where sql_id='&SQL_ID';select * from dba_hist_sqlstat where sql_id='&SQL_ID';select * from table(DBMS_XPLAN.DISPLAY_CURSOR('&SQL_ID', NULL, 'ALL'));select * from table(DBMS_XPLAN.DISPLAY_AWR('&SQL_ID',&PLAN_HASH,NULL,'ALL'));

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-22616677034186966282007-12-23T02:06:00.000-08:002007-12-23T02:08:24.596-08:00

--1 Get DDL of the object:declareclb CLOB; pos INTEGER:=1; amt INTEGER; len INTEGER; txt VARCHAR2(4000);beginclb := dbms_metadata.get_ddl ('$OBJ_TYPE','$OBJ_NAME','$OWNER');len := LENGTH(clb);LOOPamt := nvl(INSTR (clb, chr(10), pos),len) - pos;IF amt>0 THEN txt := NVL(SUBSTR (clb, pos, amt),' '); ELSE txt:=''; END IF;pos := pos + amt + 1;DBMS_OUTPUT.put_line (SUBSTR(txt,1,250));EXIT WHEN pos>=len

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-48889351266505902752007-12-23T02:03:00.000-08:002007-12-24T03:16:22.846-08:00

--1 Move index from one tablespace to anotheralter index &OWNER.&INDEX_NAME rebuild tablespace &NEW_TS_NAME;--2 Moving index partition from one tablespace to anotheralter index &OWNER.&INDEX_NAMErebuild partition &IND_PART_NAME tablespace &NEW_TS_NAME;--3 Moving all index subpartitions from one tablespace to anotheralter index &OWNER.&INDEX_NAMErebuild subpartition &IND_SUBPART_NAME tablespace &

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-79013754817095922732007-12-23T02:01:00.000-08:002011-05-16T00:25:21.490-07:00

--Long operationsselect sid,username usern,serial#,opname,target,sofar,totalwork tot_work,units,time_remaining remaning,elapsed_seconds elapsed,last_update_time last_timefrom v&session_longops --where sid=73order by last_update_time desc;--All active sessionsselect * from v&session where status='ACTIVE'--and sid in (37,43)order by sid;--Find session's sid or process id by it's sid or process

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-85424849895696422262007-12-23T02:00:00.000-08:002007-12-23T02:01:25.278-08:00

-1 Move table from one tablespace to another-- (check for unusable indexes after that).alter table $OWNER.$TABLE_NAME move tablespace $NEW_TS_NAME;--2 Move table partition from one tablespace to another-- (check for unusable indexes and partitoned indexes after that).alter table $OWNER.$TABLE_NAMEmove partition $TAB_PART_NAME tablespace $NEW_TS_NAME;--3 Move table subpartition from one tablespace

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com3tag:blogger.com,1999:blog-8015535848309603954.post-2971281112451427312007-12-23T01:58:00.000-08:002007-12-23T02:00:04.174-08:00

-1 Move group of TABLE segments (check for unusable indexes after that)select 'alter table '||owner||'.'||segment_name||' move '||decode(segment_type,'TABLE PARTITION','partition '||partition_name,'TABLE SUBPARTITION','subpartition '||partition_name,null)||' tablespace &NEW_TS_NAME;' sqlfrom dba_segmentswhere segment_type like 'TABLE%'and tablespace_name='&TS_NAME'and owner='&OWNER'and

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-37670822082129723422007-12-23T01:56:00.000-08:002007-12-23T01:57:57.734-08:00

select * from v&log; --status of logfile groupsselect * from v&logfile order by group#; --status of logfilesselect * from v&instance; --status of the archiveralter system archive log start; --restart the archiveralter system switch logfile; --switch online logalter system set log_archive_max_processes=4;--Add logfile groupalter database add logfile group 4('&logfilename1','&logfilename2') size

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-36129990822357560372007-12-23T01:54:00.000-08:002007-12-23T01:56:06.159-08:00

I frequently talk about optimizing top resource consumption.And now most obvious question from audience is always how to find such sessions/sqls. here are ways to get both while you dont have statspack snapshot you can use them as alternate.QUERY(cusomizable,according to your workload and) and Sample Output from SPOOL1 SELECT ses.sid2 , DECODE(ses.action,NULL,'online','batch') "User"3 , MAX(

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-21891425663195837602007-12-23T01:53:00.000-08:002007-12-23T01:54:28.359-08:00

great scenario for 2gbps insertion speed......please look athttp://forums.oracle.com/forums/thread.jspa?threadID=533820&tstart=-2BT (British Telecom) ran a 82 node (or more) OPS cluster of Pyramid Nil

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-60867050335111769192007-12-23T01:51:00.000-08:002007-12-23T01:52:10.730-08:00

Recovery Writer process (RVWR)The Recovery Writer process is responsible for writing to the flashback logs in the flash recovery area.These logs are required to restore the database to a previous point in time by using the "flashback" option for Oracle databases (Oracle 10g and later).U enable the flashback feature in your database and c its power

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-88984060519999749212007-12-23T01:50:00.000-08:002007-12-23T01:51:15.980-08:00

I installed ORACLE SPOTLIGHT for RAC and found LOG_BUFFER was shown to occupy unusually large value, then I investigated and found fixed sga and log buffer are given a one granule size(4m) irrespective of log_buffer value.SQL> select * from v$sgainfo;NAME BYTES RES-------------------------------- ---------- ---Fixed SGA Size 1290952 NoRedo Buffers 2899968 NoBuffer Cache Size 243269632 YesShared

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-16693050313349442812007-12-23T01:49:00.001-08:002007-12-23T01:49:54.412-08:00

guy 1: a table has 10,00000 db blocksguy 1: it has 9999999999 rowsguy 2: vempires r on the floorguy 1: on column productid there are 23 distinct valuesguy 1: what index would u preferguy 2: b+treeguy 1: nopeguy 1: this column has very low cardinalityguy 2: kguy 2: sirguy 1: this column has very low cardinalityguy 1: so very low selectivity . if it was highly selctive only then b+treeguy 2: yupguy

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-90809246759731559292007-12-23T01:48:00.001-08:002007-12-23T01:48:58.383-08:00

Asked by a old DBA friend about waits caused by wait event "OS THREAD STARTUP" found in his 10g RAC(4 nodes on solaris with ASM)SELECT DECODE (session_state, 'WAITING', event, NULL) event,session_state, COUNT(*), SUM (time_waited) time_waitedFROM gv$active_session_historyWHERE sample_time > SYSDATE - 1GROUP BY DECODE (session_state, 'WAITING', event, NULL),session_state order by time_waited desc;

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com28tag:blogger.com,1999:blog-8015535848309603954.post-76954317745290913132007-12-23T01:46:00.000-08:002007-12-23T01:47:40.242-08:00

focussing on vulenrable part of RACRAC gives you high availablity and performance,but what if you dont have clustered disks and your voting disk or cluster registry fails. from 10g R2 these can be mirrored but you should regularly backup and voting/ocr disk.Also you should be heedfull to run integrity test.manual mirriring of voting disk bequery for current voting disk :C:\>crsctl query css

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-60803965471270947512007-12-23T01:44:00.001-08:002007-12-23T01:45:27.632-08:00

case : scott user wantt to access objects of the sales user in same database by using dblink.(assume he has select any table privilege)SQL> conn scott/tigerConnected.SQL> select * from session_privs;PRIVILEGE----------------------------------------CREATE SESSIONALTER SESSIONUNLIMITED TABLESPACECREATE TABLECREATE CLUSTERCREATE SYNONYMCREATE VIEWCREATE SEQUENCECREATE DATABASE LINKCREATE

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-24495729994616469572007-12-23T01:42:00.000-08:002007-12-23T01:43:39.847-08:00

Prerequisite: RHEL 3 has been installed with all required packages.Also check, if you need OS Patch. For install of 9i u need 3006854 patch.Not needed for oracle 10gInstall the 3006854 patch:unzip p3006854_9204_LINUX.zipcd 3006854sh rhel3_pre_install.sh1. system configuration changeLogin from root user and add following entries to /etc/sysctl.conf file:kernel.shmmax = 2147483648kernel.shmmni =

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-58801342232598992852007-12-23T01:37:00.000-08:002012-02-02T08:16:34.089-08:00

10g RAC installed on windows 2003 enterprize edition using vmware. below links were major help to me. http://www.oracle-base.com/articles/10g/OracleDB10gR2RACInstallationOnWindows2003UsingVMware.php http://www.dbasupport.com/oracle/ora10g/RACingAhead0101.shtml http://forums.oracle.com/forums/thread.jspa?messageID=1123638 http://www.idevelopment.info/data/Oracle/DBA_tips/Oracle10gRAC/

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com7tag:blogger.com,1999:blog-8015535848309603954.post-48389903435555065942007-12-22T13:09:00.000-08:002007-12-22T13:11:07.352-08:00

Contents Introduction Overview of Steps to handle a Corruption Corruption due to NOLOGGING or UNRECOVERABLE (1) Determine the Extent of the Corruption Problem (2) Replace or Move Away from Suspect Hardware (3) Which Objects are Affected ? Options for various Segment Types: CACHE CLUSTER INDEX PARTITION INDEX LOBINDEX LOBSEGMENT ROLLBACK TABLE PARTITION

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-30788500323117191982007-12-22T13:07:00.000-08:002007-12-22T13:09:03.400-08:00

How to Install, Configure, Check and Troubleshoot VERITAS NetBackup 4.5 for OraclePURPOSE The purpose of this document is to act as a 'quick start' guide for Installing, Configuring, Checking and Troubleshooting VERITAS NetBackup for Oracle and its integration with Oracle RMAN. SCOPE & APPLICATION This document is aimed at Support Personnel. It is not intended as a replacement for

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-58596344549089155402007-12-22T12:01:00.001-08:002007-12-22T12:01:45.025-08:00

PURPOSE-------The purpose of this bulletin is to demonstrate the usage of the server parameter file, a new feature in 9i, in a Real Application Clusters environment. SCOPE & APPLICATION-------------------This Article is for database administrators of ORAC environments looking toimplement the server parameter file feature in their Application Clustersenvironment.THE SERVER PARAMETER FILE IN A REAL

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-15646294779733396742007-12-22T11:57:00.000-08:002007-12-22T11:58:42.554-08:00

PURPOSE-------This article describes how you can recreate your controlfile in RAC. SCOPE & APPLICATION-------------------For DBA's requiring to recreate the controlfile. WARNING: -------- You should only need to recreate your control file under very special circumstances: - All current copies of the control file have been lost or are corrupted. - You need to change a "hard" database parameter

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com8tag:blogger.com,1999:blog-8015535848309603954.post-84804641591427838132007-12-20T10:21:00.000-08:002007-12-20T10:23:01.143-08:00

Abstract This script will monitor the usage of indexes on the database.Instructions Execution Environment: SQL, SQL*PlusAccess Privileges: Requires DBA access privileges to be executed.Usage: sqlplus sys/Instructions: Copy the script to a file and execute it from SQL*Plus.PROOFREAD THIS SCRIPT BEFORE USING IT! Due to differences in the way text editors, e-mail packages, and

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-90076781577193665482007-12-20T10:20:00.002-08:002007-12-20T10:21:44.564-08:00

PURPOSE To show how to view all indexes being monitored. SCOPE & APPLICATION Instructional.Viewing All Indexes Being Monitored Under Another User's Schema:================================================================V$OBJECT_USAGE does not display rows for all indexes in the database whose usage is being monitored.'ALTER INDEX MONITORING USAGE' places an entry in V$OBJECT_USAGE for that

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-10948012799798474602007-12-20T10:20:00.001-08:002007-12-20T10:20:49.283-08:00

PURPOSE-------The purpose of this document is to explain how to find unused indexesusing the new feature in Oracle9: "Identifying Unused Indexes" viaALTER INDEX MONITORING USAGE, as mentioned in Oracle9i Database Administrator's Guide, Chapter 11.The clause MONITORING / NOMONITORING USAGE is useful in determiningwhether an index is being used. SCOPE & APPLICATION-------------------This article

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-89056024935438482762007-12-20T10:15:00.000-08:002007-12-20T10:20:02.839-08:00

Checked for relevance on 03-July-2007PURPOSE This document explains how to identify unused indexes in order to remove them. SCOPE & APPLICATION DBAs must be aware that unused indexes: * consume storage space * degrade performance by unnecessary overheads during DML operationsREFERENCES Note 144070.1 Identifying unused indexes in Oracle9iHow to Identify Unused Indexes in Order to

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com5tag:blogger.com,1999:blog-8015535848309603954.post-60997330870707545102007-12-06T04:58:00.000-08:002007-12-06T04:59:29.598-08:00

The following procedure is a step-by-step guide (Cookbook) with tips and information for installing Oracle Database 10g with Real Application Cluster (RAC) on Red Hat Enterprise Linux Advanced Server 3. The primary objective of this article is to demonstrate a quick installation of Oracle 10g with RAC on RH AS 3. This article covers Oracle Cluster File System (OCFS), Oracle's Automatic Storage

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-45073379591017353562007-12-06T04:56:00.000-08:002007-12-06T04:57:50.754-08:00

Using Automatic Storage ManagementThis chapter briefly discusses some of the concepts behind Automatic Storage Management and describes how to use it. It contains the following topics:What Is Automatic Storage Management?Administering an ASM InstanceConfiguring the Components of Automatic Storage ManagementUsing Automatic Storage Management in the DatabaseViewing Information About Automatic

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-62740642153489761112007-12-06T04:54:00.000-08:002007-12-06T04:55:52.152-08:00

Why Oracle's Automatic Storage Management?by Sreeram SurapaneniOracle Database 10g's mantra is simpler, more automated database management. We DBAs cannot help but get excited about all the new technology that Oracle routinely releases. With the release of Oracle's Volume Manager and File system built into the Database kernel (ASM) that enthusiasm cannot be overstated. While this Oracle 10g

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-56578531780273097842007-12-06T04:47:00.000-08:002012-02-09T08:25:14.798-08:00

Automatic Storage Management (ASM) in Oracle Database 10g Automatic Storage Management (ASM) is a new feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, controlfiles and logfiles. Overview of Automatic Storage Management (ASM)  Initialization Parameters and ASM Instance Creation Startup and Shutdown of ASM Instances Administering ASM Disk

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-4010679584440184572007-12-06T03:46:00.000-08:002007-12-06T03:47:20.436-08:00

Subject: Applying Patch Sets / Interim Patches with Physical Standby Database in Place Doc ID: Note:187242.1 Type: REFERENCE Last Revision Date: 09-FEB-2006 Status: PUBLISHED PURPOSE-------The procedures below contain information about applying a patchset to your current release of Oracle for a configuration that includes one ormore physical standby databases. This information only

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com15tag:blogger.com,1999:blog-8015535848309603954.post-91908264828355627482007-11-29T23:28:00.000-08:002007-11-29T23:30:10.699-08:00

PURPOSE This article discusses the configuring and troubleshooting cases for local connections to the Oracle database (9i through 11g Release 1). The major reference for database setting procedures is from the Oracle online documentation.[Edit section] OVERVIEW [Edit section] COMMON ERRORS [Edit section] ORA-12154 Oracle Database Error Message ORA-12154 TNS:could not resolve the connect

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com5tag:blogger.com,1999:blog-8015535848309603954.post-83002966499311936182007-11-25T22:10:00.000-08:002007-11-26T23:35:52.790-08:00

V$DB_OBJECT_CACHEThis view provides object level statistics for objects in the library cache (sharedpool). This view provides more details than V$LIBRARYCACHE and is useful forfinding active objects in the shared pool.Example 24–1 Summary of Shared Pool Executions and Memory UsageThe following query shows the distribution of shared pool memory across differenttype of objects. It also shows if any

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-43856590844252462042007-11-24T04:48:00.000-08:002007-11-24T04:53:37.317-08:00

Dynamic Performance TablesThroughout its operation, Oracle maintains a set of virtual tables that record currentdatabase activity. These tables are created by Oracle and are called dynamicperformance tables.Database administrators can query and create views on the tables and grant accessto those views to other users. These views are called fixed views because theycannot be altered or removed by

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-46564696213965642522007-11-23T06:50:00.000-08:002007-11-23T06:52:33.533-08:00

Example 24–11 Finding the Sessions Holding the LockFind the (ID1, ID2, type) for sessions waiting for a lock (LMODE=0).Find the session holding the lock (REQUEST=0) for that ID1, ID2, type.SELECT lpad(' ',DECODE(request,0,0,1))||sid sess, id1, id2, lmode, request, typeFROM V$LOCKWHERE id1 IN (SELECT id1 FROM V$LOCK WHERE lmode = 0)ORDER BY id1,requestSID ID1 ID2 LMODE REQUEST TY------ ----------

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-50163428306881486992007-11-23T01:06:00.000-08:002007-11-23T01:10:54.905-08:00

Here are detailed instructions on how to configure your database in order to get every 'ORA-'-error from the alert.log to your email address or mobile phone as an SMS message. I have tested all that with 8i and 9i databases and it works fine. Probably my solution is not the optimal one, so all suggestions for improvement are more than wellcome.Step 1. If JVM (Java Virtual Machine) has been

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-85278261885653441812007-11-23T01:02:00.000-08:002007-11-23T01:05:45.873-08:00

The official method is OEM, it provides nice features in this area as well.Also tried other method in test environment.In 8i we can create event triggers like this: CREATE or replace TRIGGER mail_errors AFTER SERVERERROR ON DATABASEdeclaremail_conn utl_smtp.connection;BEGINmail_conn :=utl_smtp.open_connection('hostname',100);utl_smtp.helo(mail_conn,'hostname');utl_smtp.mail(mail_conn,'user@

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-43499415862325576022007-11-19T21:40:00.000-08:002007-11-19T21:41:25.325-08:00

The Steps that we followed while enabling archivelog mode in a RAC database.steps:-1) Backup the database!0) Shut down all instances of the database, except the one upon whichthe changes will be made.1) alter system set cluster_database=false scope=spfile;-- verification---------------SQL> show parameter cluster_databaseNAME TYPE VALUE-------------

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com3tag:blogger.com,1999:blog-8015535848309603954.post-60122275549015151922007-11-19T21:39:00.000-08:002007-11-19T21:40:03.847-08:00

Migrate to the server parameter file by creating and editing the server parameter file using the procedures described in this section. Server Parameter File Placement in Real Application Clusters For single-node cluster-enabled configurations, or if you are using a cluster file system, place the server parameter file on a file system. Otherwise, place the server parameter file on a shared raw

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-19822010971085600432007-11-19T21:37:00.000-08:002007-11-19T21:39:17.757-08:00

« Creating a DTP enabled RAC ServiceHOWTO: Manually Convert Single Instance to RAC on UnixNow, I know what you are going to say and yes I know there is a new utility in 10g called rconfig that will do all this for you but just in case you want to do it the old fashioned way I thought I’d include the steps to do it. So, here we go…1. Convert the oracle home on each Node(Note 211177.1 on Metalink)a

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com5tag:blogger.com,1999:blog-8015535848309603954.post-12646179611678502292007-11-01T20:48:00.000-07:002007-11-01T20:49:19.358-07:00

PurposeThis document gives a overview of the SQL tuning issues. Scope & Application For all DBAs SQL Query Handing in Oracle Every statement submitted to the Oracle engine passes through a number of phases that determine for example the statements validity or if it has run before etc. In terms of SQL Tuning the most important area is Query optimization which is nominally part of the PARSE phase.

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-3415342205653061312007-11-01T20:47:00.000-07:002007-11-01T20:48:34.237-07:00

PurposeThis document records a number of Frequently Asked Questions pertaining to the tuning of SQL statememts.Scope & Application For all DBAs Query Tuning FAQ Why is an index not used? Why is a particular query slow? Why is a particular query slower than it used to be? Why is a particular query slower since upgrading? Why does a particular query's runtime vary? Why does the execution plan for a

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-3940007753847447342007-11-01T20:46:00.000-07:002007-11-01T20:47:44.556-07:00

Purpose This document gives an overview of some of the tools that can be used to discover more about SQL execution. The article provides information covering SQL_TRACE, TKProf, Explain Plan and Autotrace. Scope & Application For all DBAs Overview Reference for SQL_TRACE, TKProf and Explain Plan Oracle provides extensive tracing and interpretation tools to assist analysts diagnose and resolve

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-51901467921754216312007-11-01T20:45:00.000-07:002007-11-01T20:46:39.381-07:00

PURPOSEThis document gives general advice on the use of TKPROF.SCOPE & APPLICATIONFor users needing advice on how to use TkProf.Tkprof is an executable that 'parses' Oracle trace files to produce morereadable output. Remember that all the information in TkProf is availablefrom the base trace file.If you have a system that is performing badly, a good way to identify problem SQL statements is to

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-79329295644137858692007-11-01T20:44:00.000-07:002007-11-01T20:45:55.930-07:00

Tracing Statements------------------You can automatically get a report on the execution path used by the SQL optimizer and the statement execution statistics. The report is generatedafter successful SQL DML (Data Manipulation Language - that is, SELECT, DELETE,UPDATE and INSERT) statements. It is useful for monitoring and tuning the performance of these statements. Controlling the Report ------

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-46558047550744835952007-11-01T20:42:00.000-07:002007-11-01T20:44:34.553-07:00

TKPROF and Problem Solving==========================Purpose-------This document discusses the use of the following: * SQL TRACE * EXPLAIN PLAN * TKPROFScope & Application--------------------For users wanting to obtain a query plan and/or execution times for their queries.Related Documents------------------The majority of the material covered in this document

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-76536433273590636522007-10-31T01:17:00.000-07:002007-10-31T01:18:44.559-07:00

Interpreting Explain Plan=========================What's an explain plan?~~~~~~~~~~~~~~~~~~~~~~~An explain plan is a representation of the access path that is taken when a query is executed within Oracle.Query processing can be divided into 7 phases: [1] Syntactic - checks the syntax of the query [2] Semantic - checks that all objects exist and are

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-108224551161888342007-10-24T06:26:00.002-07:002007-10-24T06:27:36.675-07:00

USING CRON WITH ORACLEby Raghu ViswanathanOracle Support - Unix GroupThe objective of this bulletin is to acquaint the reader with the use of cron and to provide some examples on how it is used with ORACLE. We will use the Unix att universe for the purpose of discussion. Differences between att and bsd are documented at the end of this report.For simplicity, let us assume that the database is

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-5464512938962844202007-10-24T06:26:00.001-07:002007-10-24T06:26:54.513-07:00

PURPOSE:========HOW TO RUN A SQL PLUS SCRIPT FROM A CRON JOB.SCOPE & APPLICATION:=====================This article is intended for an audience having knowledge about unix and sql.EXPLANATION:============Cron is a mechanism for planning and scheduling batch jobs. The daemon "crond" is started automatically on system boot up. It runs one check per minute to see if there are any jobs to execute.

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-63771982467815504332007-10-24T06:24:00.000-07:002007-10-24T06:25:54.329-07:00

Contention on sys.dualSYS owned dual table was introduced by Oracle long back and since then the Application Development team across the globe has been using this table for some internal processing. Some of the common queries on DUAL table used by the application team are :select sysdate from dual;select sequence.nextval from dual;select sys_context('USERENV','SESSION_USER') from dual; DUAL being

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-20362300447532148922007-10-23T23:13:00.000-07:002007-10-23T23:14:30.038-07:00

Why isn't my index getting used?There are many possible causes of this. In this section, we'll take a look at some of the most common.Case 1We're using a B*Tree index, and our predicate does not use the leading edge of an index. In this case, we might have a table T with an index on T(x,y). We query SELECT * FROM T WHERE Y = 5. The optimizer will tend not to use the index since our predicate did

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-91283866264808866752007-10-23T23:12:00.000-07:002007-10-23T23:13:32.605-07:00

by Jonathan LewisThe question in the title of this piece is probably the single most frequently occurring question that appears in the Metalink forums and Usenet newsgroups. This article uses a test case that you can rebuild on your own systems to demonstrate the most fundamental issues with how cost-based optimisation works. And at the end of the article, you should be much better equipped to

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com9tag:blogger.com,1999:blog-8015535848309603954.post-65303253455231102112007-10-23T06:33:00.000-07:002007-10-23T06:34:29.862-07:00

TopicsWhy and when should one tune performance? What database aspects should be monitored? Where should the tuning effort be directed? What tuning indicators can one use? What tools/utilities does Oracle provide to assist with performance tuning? What is STATSPACK and how does one use it? When is cost based optimization triggered? How can one optimize %XYZ% queries? Where can one find I/O

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-59297389385184899792007-10-23T05:08:00.000-07:002007-10-23T05:09:08.273-07:00

Symptom(s)~~~~~~~~~~The average receive time for current block and the global cache current block receive time statistics are unusually high even though database performancedoes not seem to be affected.Change(s)~~~~~~~~~~Running statspack on 9.2 RAC.Cause~~~~~~~This is a statistics bug. To verify that this is the problem, check the averagewait time for the 'global cache null to x' wait event.

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-80483722761694439862007-10-23T05:06:00.000-07:002012-02-02T08:18:55.083-08:00

Overview -------- This script is intended to provide a user friendly guide to troubleshoot RAC hung sessions or slow performance scenerios. The script includes information to gather a variety of important debug information to determine the cause of a RAC hang. The script will create a file called racdiag_.out in your local directory while dumping hang analyze dumps in the user_dump_dest(s

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com4tag:blogger.com,1999:blog-8015535848309603954.post-70785145224996291292007-10-16T21:23:00.000-07:002007-10-16T21:28:28.930-07:00

STATSPACK FREQUENTLY ASKED QUESTIONSCONTENTS--------1) What is StatsPack and how does STATSPACK work? Where are StatsPack READMEfiles? The README files contain the most up to date inforamtion about StatsPack. See Note 149115.1: What is StatsPack and where are the READMEs?Checked for relevance on 16-May-2007 PURPOSE-------This note is intended to provide an overview of what the StatsPack

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-17345525763008096932007-10-14T20:44:00.000-07:002007-10-14T20:45:52.426-07:00

Subject: Script: To Monitor the Usage of Indexes Doc ID: Note:1033478.6 Type: SCRIPT Last Revision Date: 30-MAY-2007 Status: PUBLISHED Abstract This script will monitor the usage of indexes on the database. Product Name, Product Version Oracle Server, 7.3 to 10.0 Platform Platform Independent Date Created 09-Jul-1997 Instructions Execution Environment: SQL, SQL*

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-37598380033604463322007-10-14T20:42:00.001-07:002007-10-14T20:43:32.667-07:00

Subject: Viewing All Indexes Being Monitored Under Another User's Schema Doc ID: Note:160712.1 Type: BULLETIN Last Revision Date: 11-JUL-2007 Status: PUBLISHED PURPOSE To show how to view all indexes being monitored. SCOPE & APPLICATION Instructional.Viewing All Indexes Being Monitored Under Another User's Schema:================================================================V$

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-3462021633055554772007-10-14T20:42:00.000-07:002007-10-14T20:43:28.635-07:00

Subject: Viewing All Indexes Being Monitored Under Another User's Schema Doc ID: Note:160712.1 Type: BULLETIN Last Revision Date: 11-JUL-2007 Status: PUBLISHED PURPOSE To show how to view all indexes being monitored. SCOPE & APPLICATION Instructional.Viewing All Indexes Being Monitored Under Another User's Schema:================================================================V$

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-69602166544434294342007-10-14T20:40:00.000-07:002007-10-14T20:41:31.989-07:00

Subject: Identifying unused indexes in Oracle9i Doc ID: Note:144070.1 Type: BULLETIN Last Revision Date: 22-APR-2007 Status: PUBLISHED PURPOSE-------The purpose of this document is to explain how to find unused indexesusing the new feature in Oracle9: "Identifying Unused Indexes" viaALTER INDEX MONITORING USAGE, as mentioned in Oracle9i Database Administrator's Guide, Chapter 11.The

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-36047252160231679252007-10-14T20:38:00.000-07:002007-10-14T20:39:03.675-07:00

Subject: Identifying Unused Indexes with the ALTER INDEX MONITORING USAGE Command Doc ID: Note:136642.1 Type: BULLETIN Last Revision Date: 02-JUL-2007 Status: PUBLISHED Checked for relevance on 03-July-2007PURPOSE This document explains how to identify unused indexes in order to remove them. SCOPE & APPLICATION DBAs must be aware that unused indexes: * consume storage space *

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-16962316716703860882007-10-11T06:29:00.001-07:002007-10-11T06:29:30.762-07:00

A tablespace is a logical storage unit. Why we are say logical because a tablespace is not visible in the file system. Oracle store data physically is datafiles. A tablespace consist of one or more datafile.Type of tablespace?System Tablespace• Created with the database • Required in all database • Contain the data dictionary Non System Tablespace: • Separate undo, temporary, application data and

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-63241194897686071082007-10-11T06:27:00.000-07:002007-10-11T06:28:16.834-07:00

How to retrieve tablespace default storage Parameters?SELECT TABLESPACE_NAME "TABLESPACE", INITIAL_EXTENT "INITIAL_EXT", NEXT_EXTENT "NEXT_EXT", MIN_EXTENTS "MIN_EXT", MAX_EXTENTS "MAX_EXT", PCT_INCREASE FROM DBA_TABLESPACES;TABLESPACE INITIAL_EXT NEXT_EXT MIN_EXT MAX_EXT PCT_INCREASE ---------- ----------- -------- ------- ------- ------------ RBS 1048576

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-37271713684421038572007-10-11T06:26:00.000-07:002007-10-11T06:27:06.909-07:00

How to drop a datafile from a tablespaceImportant : Oracle does not provide an interface for dropping datafiles in the same way you would drop a schema object such as a table or a user.Reasons why you want to remove a datafile from a tablespace:• You may have mistakenly added a file to a tablespace. • You may have made the file much larger than intended and now want to remove it. • You may be

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-14771467028382164682007-10-11T06:21:00.000-07:002007-10-11T06:23:32.577-07:00

What is datafile? Datafiles are physical files of the OS that store the data of all logical structures in the database. Datafile must be created for each tablespace. How to determine the number of datafiles? At least one datafile is required for the SYSTEM tablespace. We can create separate datafile for other teblespace. When we create DATABASE , MAXDATAFILES may be or not specify in create

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-7083154413507482672007-10-11T06:05:00.000-07:002007-10-11T06:06:59.487-07:00

Subject: Statistics Package (STATSPACK) Guide Doc ID: Note:394937.1 Type: HOWTO Last Revision Date: 11-APR-2007 Status: PUBLISHED In this Document Goal Solution References--------------------------------------------------------------------------------Applies to: Oracle Server - Enterprise Edition - Version: 10.2.Information in this document applies to any platform.GoalRDBMS version

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-39951272052534196052007-10-11T06:04:00.000-07:002007-10-11T06:05:28.862-07:00

Subject: FAQ for Database Performance Doc ID: Note:146560.1 Type: FAQ Last Revision Date: 01-SEP-2006 Status: PUBLISHED ORACLE SERVER - RDBMS ------------------------------------ DATABASE PERFORMANCE ------------------------------------- FREQUENTLY ASKED QUESTIONS ---------------------------------------------- Last update: Jul-6-2001 QUESTIONS --------------- 1. What are the prioritized

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-4685694500390248542007-10-11T06:03:00.000-07:002007-10-11T06:04:34.619-07:00

Subject: Systemwide Tuning using STATSPACK Reports Doc ID: Note:228913.1 Type: BULLETIN Last Revision Date: 13-FEB-2003 Status: PUBLISHED Systemwide Tuning using StatsPack ReportsPURPOSE This article is a reference to understand the output generated by the STATSPACK utility. Since performance tuning is a very broad area this document only provide tuning advice in very specific areas.

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-28655389971617205632007-10-11T05:59:00.000-07:002007-10-11T06:00:46.193-07:00

Subject: Tuning I/O-related waits Doc ID: Note:223117.1 Type: TROUBLESHOOTING Last Revision Date: 05-APR-2007 Status: PUBLISHED -------PURPOSE-------This article provides guidelines for tuning an Oracle databasewhen the main source of contention is I/O-related. -------------------SCOPE & APPLICATION-------------------The techniques described here can be followed when:o Statspack or AWR

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-61055349395502140772007-10-11T03:23:00.000-07:002007-10-11T03:24:55.389-07:00

fact: Oracle Server - Enterprise Edition 8.1fact: Oracle Server - Enterprise Edition 9symptom: Cannot drop partitionsymptom: ORA-02149: Specified partition does not existsymptom: ORA-00942: table or view does not existsymptom: ORA-14048: a partition maintenance operation may not be combined with othercause: Partition is created using a public or private synonym.This is Bug 1716968 :CANNOT DROP

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1tag:blogger.com,1999:blog-8015535848309603954.post-21855545183113020632007-10-11T03:19:00.000-07:002007-10-11T03:20:26.754-07:00

Subject: Performing Switchover in a Data Guard Configuration Doc ID: Note:232240.1 Type: BULLETIN Last Revision Date: 10-NOV-2003 Status: PUBLISHED Overview---------------A switchover is a role reversal between the primary database and one of its standbydatabases. A switchover operation guarantees no data loss. This is typically donefor planned maintenance of the primary system. During a

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com13tag:blogger.com,1999:blog-8015535848309603954.post-19604655452798102902007-10-11T02:41:00.000-07:002007-10-11T02:42:44.299-07:00

Subject: TX Transaction locks - Example wait scenarios Doc ID: Note:62354.1 Type: TROUBLESHOOTING Last Revision Date: 23-SEP-2005 Status: PUBLISHED Introduction~~~~~~~~~~~~ This short article gives examples of TX locks and the waits which can occur in various circumstances. Often such waits will go unnoticed unless they are of a long duration or when they trigger a deadlock scenario

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com5tag:blogger.com,1999:blog-8015535848309603954.post-68684330091262910262007-10-10T07:49:00.002-07:002007-10-10T07:50:33.670-07:00

Subject: Connect /as sysdba Fails With ORA-09925 for non Software Owners Which Are dba Group Members when Instance Is Down Doc ID: Note:392643.1 Type: PROBLEM Last Revision Date: 08-MAY-2007 Status: PUBLISHED In this Document Symptoms Cause Solution References--------------------------------------------------------------------------------Applies to: Oracle Server - Enterprise Edition

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com6tag:blogger.com,1999:blog-8015535848309603954.post-37456771612430754232007-10-10T07:49:00.001-07:002007-10-10T07:49:55.231-07:00

Subject: How to Audit Connect AS SYSDBA Using Oracle Server Doc ID: Note:103964.1 Type: BULLETIN Last Revision Date: 09-MAY-2007 Status: PUBLISHED "Checked for relevance on 09-May-2007" Purpose:~~~~~~~~How to monitor audit Connect as Sysdba ? It is not possible to audit SYSDBA connections in the same way as the other Oracle users. There are no tables within Oracle to write this audit

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-49611864685367108772007-10-10T07:48:00.001-07:002007-10-10T07:48:57.234-07:00

Subject: Setting up, Interpreting Auditing Using the Windows Event Viewer Doc ID: Note:99137.1 Type: BULLETIN Last Revision Date: 06-JUN-2007 Status: PUBLISHED "Checked for relevance on 15-May-2007" Purpose:~~~~~~~~This document explains how to setup and interpret Operating System Auditing ofOracle Database activity by using the Windows Event Viewer.Some examples are : 'Instance O901 has

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com5tag:blogger.com,1999:blog-8015535848309603954.post-31232842642356954242007-10-10T07:43:00.000-07:002007-10-10T07:44:15.215-07:00

Subject: Some examples about auditing and output of auditing Doc ID: Note:167293.1 Type: BULLETIN Last Revision Date: 04-JUN-2007 Status: PUBLISHED "Checked for relevance on 27-Mar-2007" Purpose:~~~~~~~~Purpose of the document is to show some examples of auditing output as mostarticles do not show examplesHow to set up auditing can be seen in for example:Note 41800.1 Quick Reference to

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com5tag:blogger.com,1999:blog-8015535848309603954.post-61154746165614759882007-10-10T07:41:00.000-07:002007-10-10T07:43:03.765-07:00

Subject: Quick Reference to Auditing Information Doc ID: Note:41800.1 Type: REFERENCE Last Revision Date: 09-MAY-2007 Status: PUBLISHED "Checked for relevance on 09-May-2007" *** Please note this is a quick reference page and so does NOT contain full explanations of the various statements and views.Database Audit mode~~~~~~~~~~~~~~~~~~~show parameter auditAUDIT_TRAIL DB , OS or NONE

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-35215497001148298612007-10-10T07:39:00.000-07:002007-10-10T07:41:50.134-07:00

Subject: AUDIT_SYS_OPERATIONS Set To FALSE Yet Audit Files Are Generated Doc ID: Note:308066.1 Type: PROBLEM Last Revision Date: 04-JUL-2007 Status: MODERATED In this Document Symptoms Cause Solution References--------------------------------------------------------------------------------This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com29tag:blogger.com,1999:blog-8015535848309603954.post-56739700295213555722007-10-10T07:37:00.000-07:002007-10-10T08:00:49.806-07:00

Subject: How to Audit Potential Attempts to Break a Username/Password Doc ID: Note:221944.1 Type: FAQ Last Revision Date: 12-MAR-2007 Status: PUBLISHED Purpose:~~~~~~~~How to enable audit to trace a user/terminal who is trying to break in username and password in the database? This is also a good way to Auditunsuccessful database login attempts.Solution:~~~~~~~~~Do the following steps to

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com3tag:blogger.com,1999:blog-8015535848309603954.post-14799851942526693132007-10-10T04:41:00.000-07:002007-10-10T04:42:49.968-07:00

Inside Oracle Database 10gOracle Database 10g: The Top 20 Features for DBAsby Arup NandaOver the last 27 years, Oracle has made tremendous improvements in its core database product. Now, that product is not only the world's mostreliable and performant database, but also part of a complete software infrastructure for enterprise computing. With each new release comes asometimes dizzying display of

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com2tag:blogger.com,1999:blog-8015535848309603954.post-27223032260363433772007-10-10T04:24:00.000-07:002007-10-10T04:28:14.423-07:00

Contents 1. Overview 2. Hardware Overview 3. Operating Environment Configuration 4. Disk Configuration - (Internal Disk for ORACLE_HOME) 5. Configuring the Oracle User 6. Disk Configuration - (External Disks for ASM) 7. Installing the Oracle10g Database Software 8. Applying the 10.1.0.4 Database Patchset 9. Configure Oracle Net 10. Creating the Oracle Database 11. Creating /

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com0tag:blogger.com,1999:blog-8015535848309603954.post-5384109679192747772007-10-09T06:48:00.000-07:002010-03-05T07:28:17.847-08:00

Couple of days ago i read Eddie Award’s Post on Top 50 SOA-Related Acronyms and found it very interesting. Lately i have been working on Oracle Applications RAC environments and realized that RAC had its own set of frequently used Acronyms. In this post I have put together my 'Top 50' of the RAC Acronyms. Some of these might be related to other technologies also but they find a place in this list

ayyudbahttp://www.blogger.com/profile/00046200352601718598noreply@blogger.com1