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 EST 2016 on pts/3 Last failed login: Sat Dec 24 12:06:15 EST 2016 on pts/3 There was 1… 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 DEV server)… 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
spool DEPT_NonPart_to_Part.logset timing onset time onset echo on conn SCOTT/PW –> Very Importantshow user –> Create DEPT_PART table (with partitions) EXEC DBMS_STATS.gather_table_stats(user, ‘DEPT’, cascade => TRUE);SELECT num_rows FROM user_tables WHERE table_name = ‘DEPT’; EXEC DBMS_STATS.gather_table_stats(user, ‘DEPT_PART’, cascade => TRUE);SELECT num_rows FROM user_tables WHERE table_name =… Read More
Please check my upcoming articles (Tomorrow and Day after Tomorrow) for detailed steps with examples.