Sorts Tuning in Oracle

[fa icon="calendar'] Feb 25, 2008 2:51:00 PM / by Mertech Data Systems, Inc. posted in Databases

Oracle will do sorting when executing queries that use ORDER BY, GROUP BY, when an Index is created, and when MERGE SORT is invoked by the SQL optimizer.

Read More [fa icon="long-arrow-right"]

Auto Undo Management in Oracle

[fa icon="calendar'] Feb 25, 2008 2:49:00 PM / by Mertech Data Systems, Inc. posted in Databases

Oracle 9 introduced a new way to manage rollback / undo data - an Undo Tablespace. To utilize Automatic Undo Management, create a tablespace in the database of type UNDO:


create undo tablespace UNDOTBS1 datafile '/U01/oradata/prod/undotbs_01.dbf'

Read More [fa icon="long-arrow-right"]

Redo Log File in Oracle

[fa icon="calendar'] Feb 25, 2008 2:47:00 PM / by Mertech Data Systems, Inc. posted in Btrieve

The redo log file holds transaction information. Each Commit causes a flush to the log. You have multiple log files defined - one is "active" or "online", the others are "offline". Oracle rotates through these files as each gets full. Switching active files has overhead so the suggestion is that each file can hold roughly 30 minutes or transactions.

Read More [fa icon="long-arrow-right"]

Using Multiple MySQL Ports in the Same Application

[fa icon="calendar'] Feb 25, 2008 11:56:00 AM / by Mertech Data Systems, Inc. posted in Databases

This is a code example of this command:

SET_DATABASE_PORT OF MYSQL TO PORT

Read More [fa icon="long-arrow-right"]

Issues With Oracle's Recyclebin

[fa icon="calendar'] Feb 24, 2008 6:25:00 PM / by Mertech Data Systems, Inc. posted in Databases

Since 10g Oracle introduced a new feature known as the Database Recyclebin. As an Operative System, recyclebin brings the ability to restore tables (files in OS) that are dropped (deleted).

Read More [fa icon="long-arrow-right"]

Installing MySQL in Linux CentOS/Red Hat

[fa icon="calendar'] Feb 24, 2008 5:44:00 PM / by Mertech Data Systems, Inc. posted in Databases

Installing MySQL in Linux is not a difficult task; here's the step by step guide on how to do it:

Read More [fa icon="long-arrow-right"]

Use SQL Temporary Tables and then Create a Report with a VDF WinReport Object

[fa icon="calendar'] Feb 24, 2008 5:02:00 PM / by Mertech Data Systems, Inc. posted in DataFlex

You can create temporary tables at runtime to store intermediate results from complex queries and greatly improve your performance.  

Read More [fa icon="long-arrow-right"]

How to use Oracle Instant Client

[fa icon="calendar'] Feb 24, 2008 4:52:00 PM / by Mertech Data Systems, Inc. posted in Databases

Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. OCI, OCCI, Pro*C, ODBC, and JDBC applications work without modification, while using significantly less disk space than before. Even SQL*Plus can be used with Instant Client. No recompile, no hassle.

Read More [fa icon="long-arrow-right"]

How to Create a File Dump from a MySQL Database

[fa icon="calendar'] Feb 24, 2008 3:45:00 PM / by Mertech Data Systems, Inc. posted in Databases

Create the Dump File:

mysqldump --user=<user> --password=<password> <database> --result-file=<file.sql>

Read More [fa icon="long-arrow-right"]

How to Create a Dump File from PostgreSQL

[fa icon="calendar'] Feb 24, 2008 3:29:00 PM / by Mertech Data Systems, Inc. posted in Databases

To Generate a Dump file use the pg_dump tool to create a dump file from a database/tables from a PostgreSQL database, pg_dump dumps a database as a text file or to other formats.

Read More [fa icon="long-arrow-right"]

Subscribe to Email Updates