Tags » Database



First of all, let me point out that this question has nothing whatsoever to do with VB.NET specifically so it doesn’t belong in the VB.NET forum. 418 more words


Action! Program: DBF Make

Following up the DBFINFO program the next logical step is to write a program to create a dBase file.  I was able to use the skeleton of DBFINFO so some of it will look familiar.   4,333 more words


ORA-14098 - Part 2: Primary Key vs. Unique Index

A couple of days ago I wrote about ORA-14098 during an “exchange partition” operation. The workaround was to simply disable the primary key constraint on both tables. 603 more words


How To Install Linux, Apache, MySQL, PHP (LAMP) stack On CentOS 7


A “LAMP” stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps. 1,364 more words


Datagaurd Related queries

Switch To Maximum Availability Protection Mode

Switch to the desired “maximum availability” protection mode on the primary database (from the default “maximum performance”):

SQL> select value from v$parameter where name = ‘log_archive_dest_2′; — must show LGWR SYNC… 799 more words

Oracle 11g

Performance Tuning Related queries

Monitoring session:

Find total active sessions,inactive sessions & logon time from each machine:

set lines 136 pages 999
col OSUSER for a20
col USERNAME for a20… 4,433 more words

Oracle 11g