Thursday, August 18, 2016

RAC Instance Specific Parameters

Parameter file #
*.audit_file_dest='/u01/app/oracle/admin/mipd09/adump'
*.audit_trail='db'
*.cluster_database=TRUE
*.compatible='11.2.0.4.0'
*.control_files='+STAGE/mipd09/controlfile/current.261.917625349','+STAGE/mipd09/controlfile/current.260.917625349'
*.db_block_size=8192
*.db_create_file_dest='+STAGE'
*.db_domain=''
*.db_name='mipd09'
*.db_recovery_file_dest='+STAGE'
*.db_recovery_file_dest_size=3145728000
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=mipd09XDB)'
mipd091.instance_number=1
mipd092.instance_number=2
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=314572800
*.processes=150
*.local_listener=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.90)(PORT=1521))
*.remote_listener='tnc-scan.localdomain:1521'
*.remote_login_passwordfile='exclusive'
*.sga_target=629145600
mipd091.thread=1
mipd092.thread=2
mipd091.undo_tablespace='UNDOTBS2'
mipd092.undo_tablespace='UNDOTBS1'

Instance-Specific Parameters # 


--Nikhil Tatineni--



Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...