http://netvouz.com/MondoTofu/tag/statements?feed=rss MondoTofu's bookmarks tagged "statements" on Netvouz https://en.wikipedia.org/wiki/Spaghetti_code Spaghetti code is a pejorative phrase for source code that has a complex and tangled control structure, especially one using many GOTO statements, exceptions, threads, or other "unstructured" branching constructs. It is named such because program flow is conceptually like a bowl of spaghetti, i.e. twisted and tangled. Spaghetti code can be caused by several factors, such as continuous modifications by several people over a long life cycle. Structured programming greatly decreases the incidence of spaghetti code. Software Engineering MondoTofu Thu, 19 May 2016 01:44:56 GMT http://www.oracle.com/technetwork/database/manageability/sqlmonitor-084401.html Oracle Database 11g: Real-Time SQL Monitoring Real-Time SQL Monitoring, introduced in Oracle Database 11g, provides a very effective way to identify run-time performance problems with resource intensive long-running and parallel SQL statements. Interactive Enterprise Manager screens display details of SQL execution using new, fine-grained SQL statistic that are tracked out-of-the-box with no performance penalty to production systems. Statistics at each step of the execution plan are tracked by key performance metrics, including elapsed time, CPU time, number of reads and writes, I/O wait time and various other wait times. This allows DBAs to analyze SQL execution more deeply than pre Oracle > DB 11g MondoTofu Thu, 28 Aug 2014 13:26:40 GMT