CAUTION !!!! DO NOT DO THIS ON YOUR PRIMARY. IF YOU DO THEN YOU WOULD REQUIRE MEDIA RECOVERY ON THE…
Category Database
SELECT /*+ RULE */ GRANTEE FROM SYS.DBA_ROLE_PRIVS A WHERE GRANTED_ROLE=’DBA’ AND EXISTS (SELECT NULL FROM ALL_USERS WHERE USERNAME =A.GRANTEE);
On Primary:- select thread#, max(sequence#) “Last Primary Seq Generated” from v$archived_log where first_time between (sysdate-1) and (sysdate+1) group by thread#…
Even when sessions are inactive they can be executing SQL’s in the background. You have to identify the SQL’s which…
Source –> http://oraexplorer.com/2007/11/oracle-apex-in-11g-installation/ Today I installed Oracle 11g (11.1.0.6) on my machine. I did not realize that Oracle APEX is…
Sometimes on a system it is important to know the maximum user processes does not increase so much that it…
Just found an amazing monitoring tool for Oracle Databases. All it needs is an Oracle client installed on your workstation.…
ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 5 (‘+DATA/swx/onlinelog/redo-05-01.log’,’+DATA/swx/onlinelog/redo05-02.log’) SIZE 100m, GROUP 6 (‘+DATA/swx/onlinelog/redo-06-01.log’,’+DATA/swx/onlinelog/redo-06-02.log’) SIZE 100m; ALTER DATABASE ADD LOGFILE…
IF crsctl stat res -t gives output like below, means that the VIP failed over to node 1 from node…
While creating a’ Report and Form’ Application in Oracle APEX if your using a table which has no primary key…
ADDING TAF SERVICE FOR SCAN _____________________________ ####### As “Oracle” (owner of database) user test – name of database test1- instance…
Login as owner of clusterware (grid) user cemutlo -n rac-cluster
Below is the Solaris user profiles for “grid” and “oracle” user. If you have followed Oracles official documentation for installation…
In this scenario,the standby database lost contact(connection) with primary database for few days and hundreds of redo log was switched…
SCAN (Single Client Access Name) is a new concept introduced in since 11gR2. It eliminated to have VIP )Virutal ip)…
with t as ( select to_date(‘201111′,’yyyymm’) ym from dual) SELECT * FROM ( SELECT MIN (DECODE (TO_CHAR (YM + LEVEL…
Original Article : http://searchoracle.techtarget.com/tip/Oracle-vs-SQL-Server-Why-Oracle-wins A brief comparison between Oracle and SQL Server. Oracle comes out leaps and bound ahead in this…
Query to check if there is any logon triggers defined for your database. Logon trigger is a trigger which fires…
Out of Memory Problems on Oracle 10 / Solaris 10 Many kernel parameters have been replaced by so called resource…
Sometimes it becomes necessary to add a dummy value next to a dummy column in a report. It can be…
Scenario is that we would like to export a schema called SWX residing on a Oracle 11.2.0.2 database running on…
RMAN Point-In-Time Recovery Example There are many ways to restore a database using an RMAN backup – this example assumes…
ORA-01578: ORACLE data block corrupted (file # 19, block # 461509) ORA-01110: data file 19: ‘E:\ORACLE\ORADATA\PLACID\CARA_NS.ORA’ You are getting the…
In this activity we will create Oracle 11gR2 Datagaurd using active duplication. In active duplication, we don’t need to take…