Rujukan Pangkalan_data_Oracle

  1. ↑ Dietrich, Mike (2018-02-16). "Oracle Database 18c : Now available on the Oracle Cloud and Oracle Engineered Systems". Dicapai 2018-07-06. 
  2. ↑ Lextrait, Vincent (March 2016). "The Programming Languages Beacon, v16". Dicapai 15 December 2016. 
  3. ↑ OTN Standard License
  4. ↑ Bhakthavatsalam, Namrata (August 2008). "Glossary". Oracle Database Client. Dicapai 2008-11-17. The SID automatically defaults to the database name portion of the global database name (sales in the example sales.us.example.com) until you reach eight characters or enter a period. You can accept or change the default value. 
  5. ↑ Ashdown, Lance; Kyte, Tom (2011). "Oracle Database Concepts: 11g Release 2 (11.2)". Oracle Corporation. Diarkibkan daripada asal pada 5 July 2013. Dicapai 12 July 2013. You can use tablespaces to achieve the following goals: [...] Assign a quota (space allowance or limit) to a database user [...] 
  6. ↑ Oracle FAQ
  7. ↑ "Oracle Process architecture concepts". Download.oracle.com. Dicapai 2009-12-19. 
  8. ↑ Antognini, Christian (2008). Troubleshooting Oracle Performance. Apress Series. Apress. m/s. 71. ISBN 978-1-59059-917-4. Dicapai 2011-05-05. 
  9. 1 2 Alapati, S (2005). "Chapter 14: Using Data Pump export and import". Expert Oracle Database 10g Administration. ITPro collection. Apress. m/s. 598. ISBN 9781430200666. Dicapai 2015-08-11. The worker process is named <instance>_DWnn_<pid>. It is the process that actually performs the heavy-duty work of loading and unloading data. The master process (DMnn) creates the worker process. 
  10. ↑ Carpenter, Larry (2009). Oracle Data Guard 11g Handbook. et al. Oracle Press. m/s. 173. ISBN 978-0-07-162111-3. Data Guard Monitor (DMON)[:] This Broker-controller process is the main Broker process and is responsible for coordinating all Broker actions as well as maintaining the Broker configuration files. 
  11. ↑ Debes, Norbert (2009). Secrets of the Oracle Database. Apress series. Apress. m/s. 173. ISBN 978-1-4302-1952-1. Dicapai 2011-05-02. The job queue is handled by the job queue coordinator process CJQ0 and job queue slave processes (JNNN). 
  12. ↑ Alapati, Sam; Kim, Charles (2007). "10: Data Guard". Oracle Database 11g: New Features for DBAs and Developers. Expert's voice in Oracle. Apress. m/s. 430–431. ISBN 9781430204695. Dicapai 2015-11-24. The optional net_timeout parameter to the log_archive_dest_n parameter allows the DB As to specify the number of seconds the log writer process (LGWR) waits for a response from the logwriter network server (LNS) before terminating the process. 
  13. ↑ Safaribooksonline.comNiemiec, Richard (25 June 2007). "1.30. New Background Processes in 10g". Oracle Database 10g Performance Tuning: Tips & Techniques. Oracle Press. m/s. 967. ISBN 978-0-07-226305-3. Dicapai 2009-08-12. MMON Memory Monitor process is associated with the Automatic Workload Repository new features used for automatic problem detection and self-tuning. MMON writes out the required statistics for AWR on a scheduled basis. 
  14. ↑ Safaribooksonline.comNiemiec, Richard (25 June 2007). "1.30. New Background Processes in 10g". Oracle Database 10g Performance Tuning: Tips & Techniques. Oracle Press. m/s. 967. ISBN 978-0-07-226305-3. Dicapai 2009-08-12. M000 These are MMON background slave (m000) processes. 
  15. ↑ Rich, Bert (2015). "Oracle Database Reference, 11g Release 2 (11.2): Background Processes". docs.oracle.comOracle Help Center. Oracle Corporation. Dicapai 2015-08-05. NSVn[:] Data Guard Broker NetSlave Process[:] Performs broker network communications between databases in a Data Guard environment 
  16. ↑ Kyte, Thomas; Kuhn, Darl (2014). "5: Oracle Processes". Expert Oracle Database Architecture. SpringerLink : Bücher (edisi 3). Apress. m/s. 202. ISBN 9781430262992. Dicapai 2016-08-30. Pnnn: Parallel Query Execution Servers [...] Oracle 7.1.6 introduced the parallel query capability into the database. [...] When using parallel query, you see processes named Pnnn. These are the parallel query execution servers themselves. 
  17. ↑ "Oracle Database Online Documentation 12c Release 1 (12.1) / Database Administration: F Background Processes". Oracle. 2014. m/s. 2497. Diarkibkan daripada asal pada 13 November 2014. Dicapai 12 November 2014. Process Spawner Process [...] Spawns Oracle background processes after initial instance startup 
  18. ↑ Dyke, Julian; Steve Shaw (2006). Pro Oracle database 10g RAC on Linux: installation, administration, and performance. Apress Series. Apress. m/s. 45. ISBN 978-1-59059-524-4. Dicapai 2011-05-05. In Oracle 10.1, a queue monitor coordinator (QMNC) process [...] dynamically spawns queue monitor slaves (q000 to q009). 
  19. ↑ Vallath, Murali (2006). Oracle 10g RAC Grid, Services & Clustering. Digital Press. m/s. 467. ISBN 9780080492032. Dicapai 2014-04-14. Redo data transmitted from the primary database is received by the remote file server (RFS) process on the standby system, where the RFS process writes the redo data to archived log files or standby redo log files. 
  20. ↑ Rich, Bert (2015). "Oracle Database Reference, 11g Release 2 (11.2)". docs.oracle.com. Oracle Corporation. Dicapai 2015-05-04. Performs monitoring management tasks related to Data Guard on behalf of DMON 
  21. ↑ Alapati, Sam; Kim, Charles (2008). Oracle Database 11g: New Features for DBAs and Developers. Expert's voice in Oracle. Apress. m/s. 16. ISBN 9781430204695. Dicapai 2016-06-07. New Oracle Background Processes [...] SMCO: the space management coordinator process is in charge of coordinating the work of space management-related tasks such as space reclamation, for example. 
  22. ↑ Cyran, Michele; Paul Lane (2005). "Process Architecture". Oracle Database Concepts. Oracle Corporation. Dicapai 2008-08-13. When a user runs an application program (such as a Pro*C program) or an Oracle tool (such as Enterprise Manager or SQL*Plus), Oracle creates a user process to run the user's application. 
  23. ↑ Cyran, Michele; Paul Lane (2005). "Process Architecture". Oracle Database Concepts. Oracle Corporation. Dicapai 2008-08-13. A connection is a communication pathway between a user process and an Oracle instance. 
  24. ↑ Cyran, Michele; Paul Lane (2005). "Process Architecture". Oracle Database Concepts. Oracle Corporation. Dicapai 2008-08-13. A session is a specific connection of a user to an Oracle instance through a user process 
  25. ↑ Morales, Tony (2008). "V$SESSION". Oracle Database Reference 11g Release 1 (11.1). Oracle. Dicapai 2016-04-07. V$SESSION displays session information for each current session. [...] SID [...] Session identifier 
  26. ↑ Burleson, Donald K. (2004). Physical Database Design Using Oracle. Foundations of Database Design. CRC Press. m/s. 104. ISBN 9780203506233. Dicapai 2016-04-07. [...] Oracle assigns a unique session ID into the v$session table for each individual user logged on to Oracle. 
  27. ↑ Rich, Kathy (April 2009). "Oracle Database Reference, 10g Release 2 (10.2)" V$PROCESS. docs.oracle.com. Redwood city, California: Oracle Corporation. Dicapai 2016-10-30. SPID VARCHAR2(12) Operating system process identifier 

Rujukan

WikiPedia: Pangkalan_data_Oracle http://www.lextrait.com/Vincent/implementations.ht... http://oracle.com/database http://docs.oracle.com/cd/E11882_01/server.112/e25... http://docs.oracle.com/cd/E11882_01/server.112/e40... http://download.oracle.com/docs/cd/B19306_01/serve... http://download.oracle.com/docs/cd/B28359_01/insta... http://download.oracle.com/docs/cd/B28359_01/serve... http://download.oracle.com/docs/cd/B28359_01/serve... http://www.oracle.com/technetwork/licenses/standar... http://www.oracle.com/technology/software/products...