DatabaseJournal.com Staff

[From Computer Business Review ] Oracle Corp yesterday announced a pricing promotion for the new eight-core UltraSPARC T1 server from Sun Microsystems Inc. AdvertisementOracle customers with CPU-based licenses on Sun Fire T1000 and T200 would count cores as .23% of a processor, and charged according, Oracle said. The article continues at http://www.commentwire.com/article_news.asp?guid=C7927DD7-9556-42D8-9D6D-3B2C768A6CA1

[From Banner Software Inc.] ER/DataGen provides a seamless interface to Allfusion ERwin and ER/Studio in producing “Model-driven” test data. Want to try it out? Download a fully functional evaluation copy of Datatect at Banner Software. The article continues at http://www.bannersoftware.net

[From Technology Marketing Corp.] LAS VEGAS –(Business Wire)– Dec. 5, 2005 — BEZ Systems, an innovator in the emerging market for Proactive Performance Management solutions, today announced at the Gartner Data Center Conference, a new release of BEZProphet for Oracle that both integrates with Symantec’s VERITAS i3 application performance management software and extends the reach […]

[From Krell Software] Audit trails are an important–sometimes required–part of database administration. Many systems which maintain critical information benefit from audit trails. Often government regulations such as Sarbanes-Oxley, 21 CFR Part 11, and HIPAA require audit trails on electronic records. The article continues at http://www.krell-software.com/omniaudit/index.asp

>>Script Language and Platform: Oracle This script will gather the information from /var/opt/oracle/oratab, will set the environment and will prompt you to type a valid sid. Author: Mssvng Narasimham Softenger India Pvt. Limited #!/bin/sh cls echo “Available SIDs :- n” sids=`ps -ef | grep pmon | grep -v grep |awk -F”_” ‘ { print $3 […]

[From Pervasive Software Inc.] AUSTIN, TEXAS – November 30, 2005 – Pervasive Software® Inc. today announced it plans to contribute source code for DTrace(TM) probes to the PostgreSQL community. DTrace probes provide a superior interface for monitoring the PostgreSQL engine and allow for more effective tuning. Pervasive also formally welcomed Sun Microsystems (Nasdaq: SUNW) to […]

by Paul C. Zikopoulos Since its Version 8.2.2 release, also known as Fix Pack 9, the IBM DB2 Universal Database product (DB2 UDB) has provided the capability for a concurrent data reader to access more than one result set in the same database connection and query both of those result sets concurrently. You can download […]

>>Script Language and Platform: SQLThis script will shrink the database. Author: Rio Veni DBCC SHRINKDATABASE ([databasename]) go dbcc shrinkfile (‘databasename’,10,truncateonly) Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these pages is […]

>>Script Language and Platform: Transact-SQL MS SQL Server Updated: I would like to offer you the following string functions Transact-SQL AT(): Returns the beginning numeric position of the nth occurrence of a character expression within another character expression, counting from the leftmost character. RAT(): Returns the numeric position of the last (rightmost) occurrence of a […]

[From Winnersh Triangle Web Solutions] An updated version of the SQL Documentation Tool is now available. The product automatically creates comprehensive, searchable documentation for SQL Server databases. This version supports the use of trusted database connections. The article continues at http://www.winnershtriangle.com/w/Products.SQLDocumentationTool.asp

[From Indian-Hackers] Examining the Oracle October 2005 Critical Patch Update in depth, NGSResearchers discovered a number of problems which have all since been reported to Oracle. As well as new vulnerabilities and problems with the patches for old vulnerabilities, the October 2005 CPU fails to install the patched Oracle Text (CTXSYS) components on Oracle 8.1.7.4 […]

[From Oracle Corp.] REDWOOD SHORES, Calif. 07-NOV-2005 Oracle today announced that Autodesk, Inc., Bottomline Technologies, FileNet, InforSense, Spotfire, Inc., Tom Sawyer Software, UGS, and Waters are among the many leading independent software vendors (ISVs) providing business solutions built on Oracle(r) Database 10g for the Microsoft Windows platform. These ISV solutions help customers benefit from the […]