Performance issue with particular form in EBS: Its common issue which reports by end user that they have a performance problem with particular form or form is slow responding Have the user show DBA exactly which form runs slow by select Help->Diagnostics->Trace and click in the… Read More
Steps for Update Statement Process in SGA: update processes >update emp set sal=5000 where empno=7903; step 1 when user fires update statement first it will start user processes step 2 user processes to server processes with the help of user processe interface step 3… Read More
Steps for Select Statement Process in SGA : >SELECT * FROM EMP; step 1 when user fires update statement first it will start user processes step 2 user processes to server processes with the help of user processe interface step 3 server processes to… Read More
—– Create user for using EXPDP/IMPDP : create user admin identified by PW; grant connect,resource to admin; grant unlimited tablespace to admin; grant create any view to admin; create or replace directory DBA_EXPORT as ‘/u01/app/oracle/admin/cloud12c/dpdump’ grant write on directory DBA_EXPORT to admin; grant EXP_FULL_DATABASE to… Read More
Checking Default_Temp_Tablespace : col property_name for a35 col property_value for a20 col description for a45 set linesize 300 SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’; Temp tablespace usage : set linesize 300 SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,… Read More
RMAN Backup Size : set linesize 300 SET TERMOUT OFF; COLUMN current_instance NEW_VALUE current_instance NOPRINT; SELECT rpad(instance_name, 17) current_instance FROM v$instance; SET TERMOUT ON; PROMPT PROMPT +————————————————————————+ PROMPT | Report : RMAN Status | PROMPT | Instance : ¤t_instance | PROMPT +————————————————————————+ SET ECHO OFF… Read More
SQL Server – Issue to view Alwayson Health Events If you find AlwaysOn Health Events grayed out and you are not able to see extended events. Please find below screenshot. When you connect Dashboard of AlwaysOn, you will find View AlwaysOn Health Events grayed out… Read More
Below Script is to copy one particular database role from one SQL server to another declare @RoleName varchar(50) = ‘Database_Role_Name’ declare @Script varchar(max) = ‘CREATE ROLE ‘ + @RoleName + char(13) select @script = @script + ‘GRANT ‘ + prm.permission_name + ‘ ON ‘ +… Read More
Dear Readers, In this article we will see Installing GG in AWS (Table replication in same DB). Step 1 : Download GG software Step 2 : check for xclock in AWS server. [ec2-user@ip-172-31-21-177 tmp]$ su – oracle Password: Last login: Sat Dec 24 12:03:29… Read More
Enable Instant File Initialization You may want to consider enabling Instant File Initialization (via SE_MANAGE_VOLUME_NAME a.k.a. “Perform volume maintenance tasks”) for your SQL Server startup/service account. This option allows for much faster data file allocations (CREATE AND ALTER FILE) but DOES NOT WORK FOR LOG FILE… Read More
