OLTP or DSS has nothing to do with the version of Oracle that you are
running or the operating system. OLTP stands for OnLine Transaction Process
and DSS is for Decision Support System. An OLTP database would be one where
many transactions (update, delete, inserts) occurred during the day due to
user queries, record updates, etc. A DSS would be a application such as an
Data Warehouse-type system where there would be large batch jobs run
(potentially) and system users would only be performing large queries to
meet reporting needs.


Melanie

-----Original Message-----
From: Viswanadha P.Reddy [mailto:[Email Address Removed] Friday, June 28, 2002 4:14 AM
To: LazyDBA.com Discussion
Subject: how i know my data base is OLTP or DSS


Hi List,

how i know my database is OLTP or DSS. my database version is

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for Solaris: Version 8.1.6.0.0 - Production
NLSRTL Version 3.4.0.0.0 - Production

Regards
Reddy



Oracle LazyDBA home page