DatabaseJournal.com Staff

[From Texas Memory Systems] SAN FRANCISCO, CALIFORNIA, Oracle OpenWorld Conference, October 20, 2006 – A group of Oracle database performance experts today announced the availability of StatspackAnalyzer.com. This is a freely available online tool that analyzes the data from a user’s own Statspack report and presents clear, customized recommendations for improving the performance of the […]

[From Experience Communications] Confio Software today announced Confio Ignite for RAC, developed specifically to improve performance in applications running on Oracle RAC environments. Ignite for RAC enables DBAs to bring optimal performance to complex database configurations. It is available immediately for download at www.confio.com. The article continues at http://www.confio.com/index.php

[From IT Week] Oracle could finally announce long-mooted plans for a software stack by adding a branded version of the Ubuntu Linux distribution to its database, application server and tools at the Oracle OpenWorld conference that opens on 22 October in San Francisco. The article continues at http://www.itweek.co.uk/itweek/news/2166834/oracle-linux-stack-move

[From MySQL AB] Webinar: Thursday October 19, 2006: 10:00 am PDT; 1:00 pm EDT; 17:00 GMT Are you experiencing current performance bottlenecks? Designing a new application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries? Then […]

[From Oracle Corp.] SAN JOSE, CALIF., and REDWOOD SHORES, CALIF. 10-OCT-2006 Pillar Data Systems and Oracle, today announced the general availability of the Pillar Axiom storage system and Oracle Database 10g Accelerator to deliver a storage grid that simplifies administration headaches and helps eliminate complex personnel requirements for Oracle DBAs to better administer their storage […]

by: JP Vijaykumar A detailed discussion on the setup and administration of database access and security is beyond the scope of this document. This document examines simplifying the setup and administration of database security in an ever changing / volatile environment. The majority of tasks an Oracle DBA does in maintaining the Security and Database […]

>>Script Language and Platform: SQL Server Displays UNIX POSIX time in Seconds and reverse UNIX POSIX time as Date. Usage: select dbo.POSIXTIME(’09/09/1974 04:22:000′) as UNIX_POSIX_Time_as_Secs –Result –UNIX_POSIX_Time_as_Secs ———————– –147932520 GO select dbo.ReversePOSIXTIME(147932520) as Reverse_UNIX_POSIX_Time_as_Date –Reverse_UNIX_POSIX_Time_as_Date —————————————————— –1974-09-09 04:22:00.000 GO Author: MAK if exists (select * from dbo.sysobjects where id = object_id(N’[dbo].[POSIXTIME]’) and xtype in (N’FN’, […]

[From Lumigent Technologies, Inc.] ACTON, Mass.– September 25, 2006 – Lumigent Technologies, Inc. announced Lumigent Audit DB 5.5, which further reduces the time required for compliance and IT audit preparation. Lumigent’s new policy and reporting capabilities enable users to streamline control processes, easily prove compliance, and tailor audit results for individual company stakeholders. The software […]

[From Paradigma Software] Beaverton, Oregon-based Paradigma Software, Inc announces the immediate availability of Valentina Technology Release 2.4.2 for all developer and business products, and Valentina Studio 2.4.2, now with visual SQL Query Builder. Valentina 2’s next generation, object-relational database model builds on the traditional relational database model much like C++ builds on top of the […]

>>Script Language and Platform: OracleJust look for “List of system level privileges & List of Object level privileges & Roles granted to the users” Author: Vengata Narayanan Download Script:listObj.sql 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 […]

[From Webyog Softworks Pvt. Ltd.] Bangalore, India – September 5, 2006: Webyog announced this week that SQLyog – an advanced Graphical Client for administration of the MySQL database, will be released under the Open Source GPL license. The first Open Source version (version 5.2 Beta) can be downloaded from their website http://www.webyog.com. Read interview with […]

>>Script Language and Platform: Oracle This script contains two files. First is called bkp.bat which starts listener and service(if database is down)and connects to SQL. This script then calls backup script,called bkp.sqlThe datafiles,pfile,spfile,pwd file are stored with date and time as a filename. So that we can know the actual date and time of backup. […]