HOME

▼
Showing posts with label Performance Tunning. Show all posts
Showing posts with label Performance Tunning. Show all posts
Monday, 17 May 2021

PT - IOSTAT MPSTAT Performance Monitoring commands

›
PT -  IOSTAT  MPSTAT  Performance Monitoring commands  iostat  iostat cpu  performance output at every 2 seconds iostat -c 2  iostat  overla...
Tuesday, 12 January 2021

PT - Oracle Compression Basic and advanced table example

›
 PT - Oracle Compression Basic and advanced Query to check table compression  SQL> SELECT TABLE_NAME, COMPRESSION, COMPRESS_FOR FROM USER...
Monday, 11 January 2021

PT - Using Session Waiting Events with Hung or Very Slow Sessions

›
 Using Session Waiting Events with Hung or Very Slow Sessions Scenario Preview:  We will update and check wait events of sessions SQL> co...

ORA-00382: 32768 not a valid block size, valid range [2048..16384]

›
 Scenario Preview:  Recently we perform some row migration and row chaining activity  as we find out on window operating system we are unabl...
Tuesday, 5 January 2021

PT - Fragmentation and Defragmentation Table using shrinking table

›
Table Defragmentation Methods : -  Shrinking tables Moving tables (Alter Table Move example) Online redefinition ( Row Migration Using Onlin...

PT - Row Migration Using Online Redefinition

›
Row Migration Using Online Redefinition The chaining percentage (CHAIN_PCT) is not gathered using stats gathering.  SQL> exec DBMS_STATS....

Correcting Row Chaining by using Larger Block Size

›
 Correcting Row Chaining by using Larger Block Size Row chaining Scenario Creation : SQL> DROP TABLE CUST_ORDERS; Table dropped. SQL> ...

PT - Row migration and Row Chaining

›
 Row migration caused when no space is in the block for a row update  Row chaining caused by inserting a row larger than block size Resolvin...

PT- Correcting Row Migration by Increasing PCTFREE

›
 Correcting Row Migration by Increasing PCTFREE Scenario :  We have table name CUST, After anlayze table we find out CHAIN_CNT migrated and ...
Tuesday, 8 December 2020

PT - Extracting Session level trace based on sid and serial#

›
Session level trace example  based on sid and serial# Checking the database name  SQL> @d NAME      INSTANCE_NAME    DB_UNIQUE_NAME      ...
Sunday, 29 November 2020

LOG MINER : Log miner_current_scn

›
LOGMINER - Based on SCN  Scenario Preview: We have archive log of particular date, with the help of  logminer we can extract the value based...

Log Miner : Date_Timestamp_logminer

›
LOGMINER - Based on Date and time generation Scenario Preview: We have archive log of particular date, with the help of  logminer we can ext...

NEW LOGMINER - Based on archivelog generation

›
Scenario Preview: We have archive log of particular date, with the help of  logminer we can extract the value based on archive log . In gene...