DatabaseJournal.com Staff

[From Upright Database Technology AB] Upright Database Technology AB, Uppsala, Sweden, today announced the release of Mimer SQL Engine 9.2 for Linux. Mimer SQL Engine 9.2 is the latest version of the company’s database management system (DBMS). With the introduction of the extended multilingual support in Mimer SQL 9.2, providers of localized or multilingual software […]

[From PostgreSQL Project] The PostgreSQL Global Development Group (PGDG) is pleased to announce the availability of version 7.4 of the PostgreSQL Object Relational Database Management System (ORDBMS). This release provides commercial-grade enterprise database functionality and performance with the flexibility and low total cost of ownership widely associated with Open Source software. The article continues at […]

[From Oracle Corp.] REDWOOD SHORES, Calif., Nov. 19, 2003 – (http://www.oracle.com/tellmemore/?2580243) Oracle Database 10g set a new world performance record with the first TPC-H one-terabyte benchmark on Linux. The record-setting benchmark is the result of collaboration between Lenovo, a Chinese hardware manufacturer and member of the Oracle PartnerNetwork, and Oracle’s China Development Center in Beijing […]

[From NewsFactor Network] IBM (NYSE: IBM) may hold top-dog status among relational database software providers, but that does not prevent others from carving out significant slices of the enterprise information-management pie. Among those offering alternatives to Big Blue’s DB2 market frontrunner product is Sybase (NYSE: SY) , whose flagship Adaptive Server Enterprise (ASE) software has […]

[From CNNMoney] NEW YORK (CNN/Money) – PeopleSoft Inc. may have found a way to ward off Oracle Corp.’s $7.3 billion hostile takeover bid, but at a price. In a filing with a Delaware court, Oracle said that a revised PeopleSoft program to offer its customers refunds of up to two to five times license fees […]

>>Script Language and Platform: Oracle Generates a online calendar of any month of any year based on values of month/year provided by the user. It runs well for any Oracle system environment. Author: Luis Claudio Rodrigues da Silveira /* Generates a online calendar of any month of any year based on values of month/year provided […]

>>Script Language and Platform: Oracle 9i A script to find out what’s in the tablespace. Author: Prasad Mahale SELECT A.TABLESPACE_NAME “Tablespace Name”, B.TABLESPACE_SIZE/1024/1024 “Tablespace Size MB”, A.SEGMENT_NAME “Object Name”, A.SEGMENT_TYPE “Object Type”, ROUND(A.BYTES/1024/1024,2) “Object Size MB”, ROUND(A.BYTES / B.TABLESPACE_SIZE *100,2) || ‘%’ “% Used by Object” FROM DBA_SEGMENTS A, ( SELECT TABLESPACE_NAME, SUM(BYTES) TABLESPACE_SIZE FROM […]

>>Script Language and Platform: Oracle 9i Oracle9i Buffer Hit Ratio Author: Prasad Mahale SELECT A.VALUE + B.VALUE “Logical Reads”, C.VALUE “Physical Reads”, ROUND(100 * ((A.VALUE+B.VALUE)-C.VALUE) / (A.VALUE+B.VALUE)) “Buffer Hit Ratio %” FROM V$SYSSTAT A, V$SYSSTAT B, V$SYSSTAT C WHERE A.STATISTIC# = 41 –Consistent Gets– AND B.STATISTIC# = 40 –Db Block Gets– AND C.STATISTIC# = 42 […]

[From eMediaWire] BERKSHIRE, UK (PRWEB) November 5, 2003 — Quintessence Systems (http://www.in2j.com), the only vendor providing 100% automated software technology for migrating Oracle legacy applications into Java, today announced that its in2j migration tool has been extended to support the automated migration of Oracle business logic into Java code and DB2-compliant SQL ready for deployment […]

>>Script Language and Platform: Oracle 9i Instance startup time for Oracle 9i Author: Prasad Mahale SELECT INSTANCE_NAME “Instance Name”, HOST_NAME “Host Name”, VERSION “Version”, STARTUP_TIME “Startup Time”, STATUS “Status” FROM V$INSTANCE; Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, […]

>>Script Language and Platform: Oracle This script assigns a temporary tablespace (by number of assigned users) with a database user when its temporary tablespace is wrongly associated to system tablespace or another permanent tablespace. Author: Luis Claudio Rodrigues da Silveira set echo off set newpage 0 set space 0 set pagesize 0 set feed off […]

>>Script Language and Platform: Oracle This shell script is useful to startup a database when it must be running. It checks the database status based on value of status (Y|N) in the /etc/oratab file and send an e-mail to DBA when database has been restarted. It works fine in Red Hat Linux boxes. Author: Lums […]