Posts Tagged ‘oracle’

DBA Troubleshoot Queries

+7 Top Ten most CPU TIME Queries SELECT sql_text,ROUND (CPU_TIME/1000000) "CPU_TIME in Seconds" FROM (SELECT  sql_text, CPU_TIME,rank() over ( order by CPU_TIME DESC) rank_desc FROM v$sql) WHERE rank_desc>10;  

delete statement performance impact

+16 Delete Statement Response Time  in Oracle: Below is a quick observation on my test machine. ———————————–Playing with Delete statement with enabled trigger,Logging/Nologging Below Analysis Result on below System Configuration: Two Node RAC 11gR2  created on Virtual Box CPU: 1(2.00 GHz) each node RAM: 2gb each node

CRSCTL 11G R2 Usage

+35 CRSCTL 11G R2 Utility Usage: CRSCTL Usage:  CRSCTL is an interface between user and Oracle Clusterware, which is used to perform several operations to start/stop, enable/disable the clusterware, health check, debugging Clusterware components etc. We can use this command to do operations from one node for all other nodes in the cluster, which benefited […]

Oracle Gateway for Oracle & Mysql ODBC Connection

+29 –Demo for Oracle Gateway ODBC connection between Oracle & Mysql Prerequisites:- Machine: X86_64 bit OS: RHEL 6.4 Database: Oracle , & MySql 5.5.27 RPM Gateway: Mysql Connector/ UnixODBC driver: mysql-connector-odbc-5.2.5-1.ansi.el6.x86_64.rpm ODBC driver manager: unixODBC-2.2.14-12.el6_3.x86_64 RPM –Follow below steps for Oracle Gateway ODBC connection between Oracle & Mysql:  

Increase Redo Log File Size in Oracle 10g

+5  How to Increase Redo Log File Size :   Steps to Increase Redo Log File Size : SQL> select * from v$log; GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS  FIRST_CHANGE# FIRST_TIM

11g Grid Agent Installation