Other News

Community

Tablespace Report from SQL*Plus

by Christopher Chelladurai – The following script lists all the tablespace names in the database with their type (whether permanent or temporary), extent management (whether local or dictionary), sizes, and status (online, offline, read-only). This script should be run by a DBA user in SQL*Plus.

Community

Application Performance Tuning

by Kevin Kline and Baya Pavliashvili – Many people can write computer code; few can write software that’s scalable. This article provides some of the general guidelines for application performance tuning. The rest of the articles in this series will go into details of tuning the database portion of

Community

Exporting SQL Data as XML

By Darshan Singh – In my last article, Importing XML into SQL Server 2000, we looked at various techniques to import the XML data into SQL Server. To complement that, this article will focus on some of the methods that you can use to export relational SQL data to the XML format.