Posts Tagged ‘sql’

DBA Troubleshoot Queries

+2 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;  

ORA-16038 ORA-19809 ORA-00312

+9 ORA-16038 ORA-19809 ORA-00312 Got below error during open database: ORA-16038: log 4 sequence# 1 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 4 thread 1: '/u01/oradata/cobra/redo01.log' got below error in alert log at same time during troubleshooting problem: Errors in file /export/home/oracle/admin/cobra/udump/cobra_ora_9485.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% […]

SQL

+19  Structured Query Language (SQL) Structured Query Language (SQL) is also pronounced as “sequel” which stands for Structured English Query Language. SQL was developed by IBM in the 1970s and is an ISO/ANSI standard. It was one of the first commercial languages for Edgar F. Codd’s relational model. It provides an interface to Relational Database […]

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