Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
32%
Installation Wizard into new VRC
40%
Manual into existing VRC
6%
Manual into new VRC
22%
Total votes: 50

Baanboard at LinkedIn


Reference Content

 
Items for 'English' (by date)
By Date  
Alphabetically By Date  

 

You are browsing all items of this content category sorted by date (most recent first). Note that forum posts/threads are not included here.

 

If you would like to search through the content then please refer to the Site Search page.

 

Backup & Recovery: Always switch logfile before/after online backups
By patvdv at 23 Feb 2008 - 22:53

In order to be sure that all changes generated during a hot backup are available for a recovery, Oracle recommends that the current online log be archived after the last tablespace in a hot backup is taken out of backup mode. A similar recommendation stands for after a recovery manager online database backup is taken. A wide variety of literature on backup and recovery, including the oracle documentation, suggests using the

 


Backup & Recovery: Media recovery will be required in the case of instance failure during backup mode
By patvdv at 23 Feb 2008 - 22:50

If an instance crashes or is aborted while one of the tablespaces is in backup mode, the tablespace(s) will appear to need media recovery upon startup. In normal instance failure situations, automatic crash recovery using the online redologs will be automatically performed, with no intervention required.

 


Backup & Recovery: Hot backup mode stops writing to the datafiles
By patvdv at 23 Feb 2008 - 22:25

During an Oracle tablespace hot backup, a script or program puts a tablespace into backup mode, then copies the datafiles to disk or tape, then takes the tablespace out of backup mode. Although these steps are widely understood, the idea that datafiles are not written during backup mode is probably the most alarming and widely held misconception about Oracle. So many people think this is true, that it is actually asserted as fact in the backup/recovery sections of a number of major published books on Oracle.


General Practices: Count (1) is better than count (*)
By patvdv at 23 Feb 2008 - 22:18

The idea that you get faster results by selecting count(1) or count('x') or some similar literal value rather than count(*) has been poplar ever since I began working with Oracle in 1994. The truth is that Oracle8's cost-based optimizer will do an index fast full scan on the first unique index on a not-null column (usually the primary key) if it is available. If no such index is available, a full table scan will be performed. This behavior is the same under the cost-based and rule-based optimizers no matter what you put in the parentheses of the count function.


Introduction
By patvdv at 23 Feb 2008 - 22:01

The halls of the companies and institutions using Oracle's database echo with the slightly raised voices of DBAs arguing over the finer points of Oracle administration. Disputes arise because there are two kinds of DBAs. Some DBAs base their methods on recommendations they read or heard somewhere, without completely understanding the reasons why. Other DBAs will do nothing without hard facts to support their methods. These latter DBAs believe that absent proof positive, even Oracle's own documentation is not to be entirely trusted.


Common DBA Misconceptions
By patvdv at 23 Feb 2008 - 22:00


Common DBA Misconceptions

by Jeremiah Wilton

 

These articles are from the Common Oracle Misconceptions series by Jeremiah Wilton at http://www.ora-600.net

Copyright (c) 2001 Jeremiah Wilton

 


Appendix B: About the Author
By patvdv at 19 Feb 2008 - 23:54

About the instructor

 


Appendix A: Glossary
By patvdv at 19 Feb 2008 - 23:52

 


Enterprise Modeler
By patvdv at 19 Feb 2008 - 23:45

The Enterprise Modeler assists in developing a vision on:

  • How to functionally structure an organization
  • How to organize the business processes of the organization
  • How to integrate the information system with these business processes

In addition, the Enterprise Modeler can also be used to assist in the actual implementation of the Baan applications by:

  • Setting parameters in BaanERP.
  • Creating BaanERP users, based on the role and employee data of the Enterprise Modeler.
  • Creating the menus and session authorizations for users.

A reference model represents a line of business or business typology and can be built from libraries (repositories) of the following enterprise-modeler components:

  • Business control diagrams
  • Business function models
  • Business process models
  • Organization models


Programming
By patvdv at 19 Feb 2008 - 23:32

Introduction

The development tools supplied by the BaanERP Tools package enable developers to program additional functionality for existing BaanERP applications or to build entirely new applications. The features provided by the development tools include:

  • The BaanERP 3GL programming language.
  • 4GL language features that enable you to add to or modify the default behaviour of sessions, reports, and the Data Access Layer.
  • Baan SQL, which enables you to retrieve database data.
  • Support for Dynamic Link Libraries (DLLs).

3GL scripts are program scripts that are either linked to sessions without forms or not linked to sessions at all. They do not have any relationship with the 4GL Engine (previously known as the Standard Program). When creating such scripts, you must specify the entire program flow, including the main function. You cannot use 4GL event sections or functions.

 



All times are GMT +2. The time now is 02:56.


©2001-2018 - Baanboard.com - Baanforums.com