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
1) Proper Documentation which is very important in order to save time and act on issue immediately.2) DB health check list for Day to Day Activities. –> Check Alert log–> Tablespaces–> Archivelog cleanup script–> Check OS Watchers scripts are running or not.–> Setup cronjob for… Read More
Follow below procedure to capture following information : 1) Tables row count. 2) Table Actual Size. 3) DBA_Tab_Modifications information. Pre requisite: This Procedure needs to be implemented if we are gathering stats daily. #############On any Dev server : (Create DB link to Standby DB from… Read More
Role of APPLSYS & APPS schema in Oracle Applications: Applsys schema contains all the tables required for administarative purpose and is same as other oracle users like AP, AR, GL etc which hold their set of tables, views etc. In the same way APPLSYS Account… Read More
PARTITIONING PARTITIONS : Dividing the large tables into small tables known as partitions Partition of single table can go in two different tablespaces Sorting can be done by partitioning thus we not require temporary tablespace Partition can be independently managed Backup and recovery… Read More
