Podobne
- Strona startowa
- Card Orson Scott Glizdawce (2)
- Dukaj Jacek Czarne oceany
- Komentarz do księgi o przyczynach. Tomasz z Akwinu
- IGRZYSKA ÂŚMIERCI 02 W pierÂścieniu ognia
- Brust Steven Teckla (2)
- Chalker Jack L Polnoc przy studni dusz
- Howard Robert E Conan Droga do tronu (SCAN dal
- Justyniusz Zarys dziejow
- Andrzej.Sapkowski. .Narrenturm.[www.osiolek.com].1
- Jordan Robert Rog Valere
- zanotowane.pl
- doc.pisz.pl
- pdf.pisz.pl
- wiolkaszka.htw.pl
Cytat
Do celu tam się wysiada. Lec Stanisław Jerzy (pierw. de Tusch-Letz, 1909-1966)
A bogowie grają w kości i nie pytają wcale czy chcesz przyłączyć się do gry (. . . ) Bogowie kpią sobie z twojego poukładanego życia (. . . ) nie przejmują się zbytnio ani naszymi planami na przyszłość ani oczekiwaniami. Gdzieś we wszechświecie rzucają kości i przypadkiem wypada twoja kolej. I odtąd zwyciężyć lub przegrać - to tylko kwestia szczęścia. Borys Pasternak
Idąc po kurzych jajach nie podskakuj. Przysłowie szkockie
I Herkules nie poradzi przeciwko wielu.
Dialog półinteligentów równa się monologowi ćwierćinteligenta. Stanisław Jerzy Lec (pierw. de Tusch - Letz, 1909-1966)
[ Pobierz całość w formacie PDF ]
.When the non-Oracle system supports array fetches, you might want toimmediately send the data fetched from the non-Oracle system by the arrayfetch to the Oracle server, without waiting until the exact value ofHS_RPC_FETCH_SIZE is reached.That is, you want to stream the data fromthe non-Oracle system to the Oracle server, and disable reblocking.You can dothis by setting the value of initialization parameterHS_RPC_FETCH_REBLOCKING to 'off'.For example, you set HS_RPC_FETCH_SIZE to 64Kbytes andHS_FDS_FETCH_ROWS to 100 rows.Assume each row is approximately 600bytes in size, and thus 100 rows is approximately 60Kbytes.WhenHS_RPC_FETCH_REBLOCKING is set to 'on' (i.e.the default), the agentwould start fetching 100 rows from the non-Oracle system.Since there is only60K bytes of data in the agent, the agent will not sent the data back to theOracle server.Instead, the agent fetches the next 100 rows from the non-Oraclesystem.Since there is now 120Kbytes of data in the agent, the first 64Kbytescan be sent back to the Oracle Server.Now there is 56Kbytes left in the agent.The agent will fetch another 100 rows from the non-Oracle system, beforesending the next 64Kbytes of data to the Oracle server.You can choose to not reblock.By setting the initialization parameterHS_RPC_FETCH_REBLOCKING to 'off', the agent will not buffer the data toaccumulate "enough" data.Instead, the first 100 rows will immediately be sentback to the Oracle8 Server.That is, the data is streamed from the non-Oraclesystem directly to the Oracle Server.Application Development with Heterogeneous Services 8-11 8-12 Oracle8 Server Distributed Database Systems APPENDI XA Heterogeneous ServicesInitialization ParametersThis appendix describes Heterogeneous Services initialization parameterswhich are set using the DBMS_HS package.All initialization parameters that can be set for Heterogeneous Services arestored in the Oracle8 Server.See Chapter 7, Administering OracleHeterogeneous Services for more information on how to set and deleteinitialization parameters using the DBMS_HS package.Heterogeneous Services Initialization Parameters A-1 HS_COMMIT_POINT_STRENGTHService: GeneralDefault value: 0Range of values: 0 to 255PurposeThe parameter HS_COMMIT_POINT_STRENGTH has the same function asthe Oracle8 parameter COMMIT_POINT_STRENGTH.Set HS_COMMIT_POINT_STRENGTH to a value relative to the importance ofthe site that will be the commit point site in a distributed transaction.TheOracle server or non-Oracle system with the highest commit point strengthbecomes the commit point site.To ensure that non-Oracle system neverbecomes the commit point site, set the value ofHS_COMMIT_POINT_STRENGTH to zero.HS_COMMIT_POINT_STRENGTH can be of importance only if the non-Oracle system can participate in the the two-phase protocol as an regular two-phase commit partner and as commit point site.This is only the case if thetransaction model is two-phase commit confirm (2PCC).See Chapter 7, Administering Oracle Heterogeneous Services for moreinformation about heterogeneous distributed transactions.See Chapter 3, Distributed Transactions , for more information about distributedtransactions and commit point sites.A-2 Oracle8 Server Distributed Database Systems HS_DB_DOMAINService: GeneralDefault value: WORLDRange of values: 1 to 119 charactersPurposeHS_DB_DOMAIN specifies a unique network sub-address for a non-Oraclesystem.HS_DB_DOMAIN is used in a similar fashion to the Oracle serverequivalent, which is described in the Oracle8 Server Administrator s Guide andthe Oracle8 Server Reference.HS_DB_DOMAIN is required if you use the OracleName Server.The parameters HS_DB_NAME and HS_DB_DOMAIN definethe global name of the non-Oracle system.Note: HS_DB_NAME and HS_DB_DOMAIN in combination must also beunique.Heterogeneous Services Initialization Parameters A-3 HS_DB_INTERNAL_NAMEService: GeneralDefault value: 01010101Range of values: 1 to 16 hexadecimal charactersPurposeHS_DB_INTERNAL_NAME specifies a unique hexadecimal numberidentifying the instance to which the Heterogeneous Services agent isconnected.This parameter s value is used as part of a transaction ID whenglobal name services are activated.Specifying a nonunique number can causeproblems when two-phase commit recovery actions are necessary for atransaction.A-4 Oracle8 Server Distributed Database Systems HS_DB_NAMEService: GeneralDefault value: HORange of values: 1 to 8 charactersPurposeA unique alphanumeric name for the datastore given to the non-Oraclesystem.This name identifies the non-Oracle system within the cooperativeserver environment.The HS_DB_NAME and HS_DB_DOMAIN define theglobal name of the non-Oracle system
[ Pobierz całość w formacie PDF ]