(Sateesh Kumar) Everyone knows, there will be lot of processes running in a system. We can see process list in Task Manager. But it gives limited information. If we want to integrate that Process list in your application, there is no solution for that. But, we can create our own Task Manager to disp
Other News
Event and Error Logging
(Scott Lysle) This article describes an approach to writing to a custom error log and to writing events into the system event log.
On finding changed values in a table with flashback
(René Nyffenegger) The as of clause in a select statement allows to see the data as of a past SCN or past point in time. So, it’s possible, for example, to compare the current data in a table with a previous data set. This is what I try to do.
Oracle DBA FAQ – Working with Database Objects in PL/SQL
This is a collection of 23 FAQs on working with database objects in PL/SQL. Clear answers are provided with tutorial exercises on running DML statements, assign table data to variables, using the implicit cursor, defining and using RECORDs with table rows.
Don’t prefix user defined stored procedure with ‘SP_’ …
(Vadivel Mohanakrishnan) I have seen in the forum that many of the members are either writing sample stored procedure in their questions / answers with a name starting as “SP_”. Its not a good practise and it would have a major hit on the performance of their Database. So just thought of warning the
MySQL Bug with FLUSH TABLES and Fulltext Indexes in > MySQL 4.1
(Kevin Burton) It seems that there’s a bug with MyISAM tables in any version of MySQL since 4.1 running fulltext indexes.
Working with Expressions, Variables and xsl:for-each in XSLT
(Jagadish Chaterjee) This is the fourth article in a series focusing on developing XSLT-oriented applications using ASP.NET 2.0. Even though the series is based on ASP.NET 2.0, I use it only as a transformation engine. The entire focus is on working with XSLT. You can use any transformation engine a
Oracle Streams Configuration: Send CDC Data to 9i
(Lewis Cunningham) The entry builds directly on my last entry, Oracle Streams Configuration: Change Data Capture. This entry will show you how to propagate the changes you captured in that entry to a 9i database.
Semantic search in IBM OmniFind Enterprise Edition, Part 2: Semantic search with UIMA and OmniFind
(Michael Baessler, Andrea Elias, Thilo Goetz and Sebastian Nelke) Walk through an end-to-end scenario for creating and deploying custom text analysis in IBM OmniFind Enterprise Edition 8.4. Find out everything you need to know from writing and testing a UIMA annotator, deploying it in OmniFind, and
SQL Server 2005 Backups
(Grant Fritchey) In the opening chapter of Craig Mullin’s book, Database Administration, he says “In many ways, business today is data”. Within most organizations the person responsible for protecting data is the database administrator… you.