1. Enable trace at instance level Put the following line in init.ora. It will enable trace for all sessions and the background processes sql_trace = TRUE to
Read More
Solution. The Oracle SQL developer is NOT supported on 64 bits JDK. To solve it, install a 32 bits / x86 JDK and update your SQL developer config file, so
Read More
i work with sql server, but i must migrate to an application with Oracle DB. for trace my application queries, in Sql Server i use wonderful Profiler tool. is there
Read More
I've worked with Oracle for some time but very much a noob with the Admin side of things and am learning, so bear with me. I cannot log on to my database (orcl_test
Read More
1. Enable trace at instance level Put the following line in init.ora. It will enable trace for all sessions and the background processes sql_trace = TRUE to
Read More
Ratings : 53 %
Oracle AUTOTRACE Fundamentals to Analyze & Tune SQL :
Ratings : 69 %
ORA-01652: unable to extend temp segment by 256 in tablespace TEMP. [nQSError: 16015] SQL statement execution failed. (HY000)
Read More
Ratings : 73 %
ORACLE TKPROF fundamentals Part 1 - Introduction to SQL Tracing & TKPROF :
Ratings : 22 %
Solution. The Oracle SQL developer is NOT supported on 64 bits JDK. To solve it, install a 32 bits / x86 JDK and update your SQL developer config file, so
Read More
Ratings : 25 %
Oracle SQL_TRACE - Beginner :
Ratings : 46 %
i work with sql server, but i must migrate to an application with Oracle DB. for trace my application queries, in Sql Server i use wonderful Profiler tool. is there
Read More
Ratings : 67 %
I've worked with Oracle for some time but very much a noob with the Admin side of things and am learning, so bear with me. I cannot log on to my database (orcl_test
Read More
Ratings : 34 %
Oracle Event 10046 Tracing the Execution :
Ratings : 62 %
1.Introduction to basic SQL*Plus and SQL commands in oracle 9i :
Ratings : 64 %
Trace Analyzer TRCANLZR TRCA) :
Ratings : 15 %
SQL: SQL Tracing Part-1 :
Ratings : 37 %
Query Tuning with tkprof :
Ratings : 22 %
ORACLE TKPROF fundamentals Part 2 - Interpret TKPROF Report :
Ratings : 64 %