EXP Computer ThinConnect4 Guide de l'utilisateur Page 117
- Page / 163
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
The standard thin server is a multi-threaded server that allows concurrent access to Oracle
Rdb by many client processes. Within a single OpenVMS process, Oracle Rdb is single-
threaded, thus the thin server has to synchronize client database activity.
Because database actions must be serialized, any action that might take a prolonged length of
time may seriously impact the overall throughput of the server.
By default the server will wait indefinitely for a lock, however, in order to try to minimize
the impact of one client thread on another you may specify the period of time the server
should wait for a lock.
If this wait is not indefinite, any thread will wait for the specified amount of time trying to
get a lock. If the lock is not granted control is returned to the server. By default, the server
will then try to get a lock ten (10) times, waiting for the specified amount of time each time,
before raising a locking exception.
Specifying a short wait duration, for example one (1) second, may help reduce the impact
that one thread may have on another sibling thread.
The lockwait switch allows control of the duration of the wait for a lock, the minimum actual
wait period being one (1) second, which is the minimum lock wait time supported by Rdb
transactions.
A lockwait of 0 is the same as starting up a transaction with NOWAIT. A lockwait of minus
one (-1) is the same as starting up a transaction with WAIT without specifying a value, which
causes the server to wait indefinitely,
The maxtries switch allows you to specify the maximum number of times the server will try
to get a lock before giving up. The default maxtries value is 10.
The higher the value you assign to the lockwait switch, the more likely that a locked object
may slow down all clients, so it is preferable to keep the lockwait at a minimum but increase
the number of lock attempts appropriately.
8.10.1 Lockwait precedence
As well as being able to specify the lockwait either at the server level or at the connection
level as shown above, Oracle Rdb allows you to specify a maximum lock wait for the
process by using the RDM$BIND_LOCK_TIMEOUT_INTERVAL logical name. In
addition a database-wide lock timeout value may be established using the LOCK TIMEOUT
INTERVAL clause of the SQL CREATE DATABASE and SQL ALTER DATABASE
statements.
The following describes the order of precedence observed when lockwait has been specified
in more than one way.
117
- Oracle® JDBC for Rdb 1
- User Guide 1
- Contents 3
- Preface 7
- Purpose of This Manual 7
- Intended Audience 7
- Document Structure 7
- Conventions 7
- Chapter 1 9
- Introduction 9
- Chapter 2 11
- Oracle JDBC for Rdb 11
- Rdb thin driver 13
- 2.3 Connection Options 14
- Chapter 3 19
- Oracle JDBC for Rdb Servers 19
- 3.2.2 Shared Memory Usage 24
- 3.2.3 Prestarted Executors 24
- 3.2.4 Executor Naming 25
- Table 3–1 Subcode 27
- Descriptions 27
- Description 27
- 3.3.2 Pool Server Operation 30
- Chapter 4 32
- Server Configuration 32
- Default Description 33
- 4.3 Configuration Files 43
- 4.3.2.1 Config Section 47
- 4.3.2.2 Session Section 47
- <session 48
- 4.3.2.3 Databases Section 49
- 4.3.2.4 Database Section 49
- 4.3.2.5 Servers Section 51
- 4.3.2.6 Server Section 51
- Chapter 5 56
- Using SSL 56
- 5.2 SSL and the Controller 59
- Chapter 6 63
- 6.1 Running the Controller 66
- 6.2 Connecting to Servers 74
- 6.2.1 Connect Command 75
- 6.3 Control Password 76
- 6.4 Server Operations 77
- 6.4.1 Closing Servers 78
- 6.4.2 Opening Servers 79
- 6.4.2.2 Command mode 80
- 6.4.3 Showing Servers 81
- 6.4.3.2 Command mode 82
- 6.4.4 Starting Servers 83
- 6.4.4.2 Command mode 84
- 6.4.5 Stopping Servers 85
- 6.4.5.2 Command mode 86
- 6.4.6 Watching Servers 87
- 6.4.7 Polling Servers 88
- 6.4.7.3 Multicast Polling 89
- 6.5 Client Operations 90
- 6.5.2 Stopping Clients 91
- 6.5.2.1 Interactive mode 92
- 6.5.2.2 Command mode 93
- Chapter 7 95
- Rdb Servers 95
- $@sys$share:rdb$setver 71 104
- 7.3 Using Pool Servers 105
- Chapter 8 108
- Other Features 108
- 8.3 Persona 110
- 8.4 Default Transaction 111
- 8.6 FetchSize 113
- 8.8 Inactivity timeouts 114
- 8.9 JDBC Hint Methods 116
- 8.10 Lockwait and Maxtries 116
- 8.10.1 Lockwait precedence 117
- 8.11 Logging 119
- 8.12 Name 119
- 8.13 Named Databases 121
- 8.14 On Start Commands 122
- 8.14.2 srv.onExecStartCmd 124
- 8.21 SET Statements 133
- 8.22 SQL Statement Cache 134
- 8.23 Trace 136
- Trace Values 138
- (S:RWE, O:RWE, G:RE, W:RE) 139
- Chapter 9 141
- 9.2 ResultSet.getBytes() 142
- Chapter 10 143
- Other Information 143
Produits connexes et manuels pour Commutateurs de réseau EXP Computer ThinConnect4
(152 pages)BoConcept Indivi2 manuels
Manuels d'utilisation et guides de l'utilisateur pour Non BoConcept Indivi2.
Nous fournissons des manuels en pdf 1 BoConcept Indivi2 à télécharger gratuitement par type de document : Manuel d'instructions
Boconcept Indivi2 Manuel d'instructions (4 pages)
marque: Boconcept | Catégorie: No info | Taille: 0.29 MB |
Table des matières
Plus de produits et de manuels pour Non BoConcept
| Modèles | Type de document |
|---|---|
| Milos |
Manuel d'instructions
BoConcept Milos Assembly Instruction,
4 pages
|
| Model 3050 |
Manuel d'instructions
BoConcept Model 3050 Assembly Instruction,
2 pages
|
| Model 2994 |
Manuel d'instructions
BoConcept Model 2994 Assembly Instruction,
9 pages
|
| 6082 |
Manuel d'instructions
BoConcept 6082 Assembly Instruction,
3 pages
|
| Melo |
Manuel d'instructions
BoConcept Melo Assembly Instruction,
4 pages
|
| Fargo |
Manuel d'instructions
BoConcept Fargo Assembly Instruction,
3 pages
|
| 5240 |
Manuel d'instructions
BoConcept 5240 Assembly Instruction,
6 pages
|
| 3160 |
Manuel d'instructions
BoConcept 3160 Assembly Instruction,
2 pages
|
| 2200 |
Manuel d'instructions
BoConcept 2200 Assembly Instruction,
4 pages
|
| 1402 |
Manuel d'instructions
BoConcept 1402 Assembly Instruction,
2 pages
|
| Model 3330 |
Manuel d'instructions
BoConcept Model 3330 Assembly Instruction,
8 pages
|
| Model 10 |
Manuel d'instructions
BoConcept Model 10 Assembly Instruction,
6 pages
|
| 38 |
Manuel d'instructions
BoConcept 38 Assembly Instruction,
8 pages
|
| Amari 70 |
Manuel d'instructions
BoConcept Amari 70 Assembly Instruction,
4 pages
|
| Model 6120 | Manuel d'instructions BoConcept Model 6120 Assembly Instruction [bs] [hr] [sr] , 3 pages |
| Model 26 |
Manuel d'instructions
BoConcept Model 26 Assembly Instruction,
2 pages
|
| Model 6150 |
Manuel d'instructions
BoConcept Model 6150 Assembly Instruction [en] [pl] ,
2 pages
|
| Model 5100 |
Manuel d'instructions
BoConcept Model 5100 Assembly Instruction,
8 pages
|
| Model 2900 900 |
Manuel d'instructions
BoConcept Model 2900 900 Assembly Instruction [en] ,
8 pages
|
| 6515 | Manuel d'instructions BoConcept 6515 Assembly Instruction, 5 pages |
© 2020, manymanuals.fr. Tous droits réservés | 0.044 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels