Wednesday, 21 May 2014

Oracle Basic Architecture

Oracle Architecture (Basic):

Below is the typical architecture of Oracle 11g. When you fire a SQL from any of the client tools like (SQL Developer/Toad/ or even SQLPLUS) below processes gets triggered at the back end.

Background Processes: It start with the database instance and perform maintenance tasks such as performing instance recovery, cleaning up processes, and writing redo buffers to disk, and so on.

Server Processes: perform work based on a client request.

clip_image001

Credits: docs.oracle.com

Terminologies & Functionality:

1. SGA

System global area. A group of shared memory structures that contain data and control information for one Oracle database instance.

2. PGA

Program global area. A memory buffer that contains data and control information for a server process.

3. Shared pool

Portion of the SGA that contains shared memory constructs such as shared SQL areas.

4. Large pool

Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA.

5. Database buffer cache

The portion of the system global area (SGA) that holds copies of data blocks. All client processes concurrently connected to the instance share access to the buffer cache.

6. Redo log buffer

Memory structure in the SGA that stores redo entries—a log of changes made to the database. The database writes the redo entries stored in the redo log buffers to an online redo log file, which is used if instance recovery is necessary.

7. Online redo log

The set of two or more online redo log files that record all changes made to Oracle Database data files and control file. When a change is made to the database, Oracle Database generates a redo record in the redo buffer. log writer (LGWR) writes the contents of the redo buffer to the online redo log.

Redo Log has set of files that protect altered database data in memory that has not been written to the data files. The redo log can consist of two parts: the online redo log and the archived redo log.

8. Shared SQL area:

An area in the shared pool that contains the parse tree and execution plan for a SQL statement. Only one shared SQL area exists for a unique statement.

9. Back Ground Processes:

A process that consolidates functions that would otherwise be handled by multiple Oracle programs running for each client process. The background processes asynchronously perform I/O and monitor other Oracle processes.

1. Mandatory Background Processes

These processes run by default in a database instance started with a minimally configured initialization parameter file

i. Process Monitor Process (PMON) :

PMON is responsible for cleaning up the database buffer cache and freeing resources that the client process was using. PMON also registers information about the instance and dispatcher processes with the Oracle Net listener

ii. System Monitor Process (SMON): is in charge of a variety of system-level cleanup duties like Performing instance recovery, Recovering terminated transactions, cleaning up unused temporary segments, Coalescing contiguous free extents.

iii. Database Writer Process (DBWn): It writes the contents of database buffers to data files. Typically database buffer is the memory area that stores copies of data blocks read from data files.

iv. Log Writer Process (LGWR) :

The log writer process (LGWR) manages the redo log buffer. LGWR writes one contiguous portion of the buffer to the online redo log.

v. Checkpoint Process (CKPT) :

The checkpoint process (CKPT) updates the control file and data file headers with checkpoint information and signals DBWn to write blocks to disk

vi. Manageability Monitor Processes (MMON and MMNL):

The manageability monitor process (MMON) performs many tasks related to the Automatic Workload Repository (AWR). For example, MMON writes when a metric violates its threshold value, taking snapshots, and capturing statistics value for recently modified SQL objects.

The manageability monitor lite process (MMNL) writes statistics from the Active Session History (ASH) buffer in the SGA to disk. MMNL writes to disk when the ASH buffer is full.

vii. Recoverer Process (RECO)

In a distributed database, the Recoverer process (RECO) automatically resolves failures in distributed transactions. The RECO process of a node automatically connects to other databases involved in an in-doubt distributed transaction.

2. Optional Background Processes:

i. Archiver Processes (ARCn):

The Archiver processes (ARCn) copy online redo log files to offline storage after a redo log switch occurs. These processes can also collect transaction redo data and transmit it to standby database destinations. ARCn processes exist only when the database is in ARCHIVELOG mode and automatic archiving is enabled.

ii. Job Queue Processes (CJQ0 and Jnnn):

Oracle Database uses job queue processes to run user jobs, often in batch mode.

iii. Flashback Data Archiver Process (FBDA):

It archives historical rows of tracked tables into Flashback Data Archives. When a transaction containing DML on a tracked table commits, this process stores the pre-image of the rows into the Flashback Data Archive.

iv. Space Management Coordinator Process (SMCO) :

The SMCO process coordinates the execution of various space management related tasks, such as proactive space allocation and space reclamation. SMCO dynamically spawns slave processes (Wnnn) to implement the task.

3. Slave Processes

Slave processes are background processes that perform work on behalf of other processes.

i. I/O Slave Processes:

I/O slave processes (Innn) simulate asynchronous I/O for systems and devices that do not support it. In asynchronous I/O, there is no timing requirement for transmission, enabling other processes to start before the transmission has finished.

ii. Parallel Query Slaves:

In parallel execution or parallel processing, multiple processes work together simultaneously to run a single SQL statement. By dividing the work among multiple processes, Oracle Database can run the statement more quickly. For example, four processes handle four different quarters in a year instead of one process handling all four quarters by itself.

134 comments :

  1. I'm so happy to find the good inofrmation On PL/SQL thanks for your effort .friends learn Oracle PLSQL e-learning By 8 years experienced trainer

    ReplyDelete
  2. Data Warehousing Training "
    Data Warehousing Online Training
    Send ur Enquiry to contact@21cssindia.com
    Introduction to Data warehousing
    Who needs Data warehouse?
    Why Data warehouse is required?
    Types of Systems" more… Online Training- Corporate Training- IT Support U Can Reach Us On +917386622889 - +919000444287 http://www.21cssindia.com/courses/data-warehousing-online-training-29.html

    ReplyDelete
  3. It's a nice blog with lot of information,thanks for sharing...
    Hi this is babu, I want to share some information for you,If you want to join any professional course visit this website
    oracle training in chennai It's a best place to learn oracle in chennai
    thanks, babu

    ReplyDelete
  4. Your blog is really useful for me. If anyone want to become an oracle certified professional reach FITA, which offers best Oracle Training in Chennai with years of experienced professionals. For more details about oracle, sql training visit this site.

    Oracle Training in Chennai

    ReplyDelete
  5. SAP Training Institute in Chennai

    Thanks for sharing this valuable information.and I gathered some information from this blog. I did SAP Training in Chennai, at FITA Academy which offer best SAP Course in Chennai with years of experienced professionals.

    SAP Institutes in Chennai

    ReplyDelete

  6. The information you posted here is useful to make my career better keep updates...If anyone want to get Cloud Training in Chennai, Please visit FITA academy located at Chennai. Rated as No.1 Cloud Computing Training Centers in Chennai

    ReplyDelete
  7. I have read your blog and i got a very useful and knowledgeable information from your blog.You have done a great job . If anyone want to get Salesforce Developer Training in Chennai, Please visit FITA academy located at Chennai Velachery. Rated as No.1 Salesforce Training Institutes in Chennai.

    ReplyDelete
  8. I gathered a lot of information through this article.Every example is easy to understandable and explaining the logic easily.Thanks.
    cloud computing training in chennai | cloud computing training chennai | cloud computing course in chennai | cloud computing course chennai

    ReplyDelete
  9. Hi , great faq collection, the interview questions you provided on Oracle SQL PL/SQL Technology is appreciable. thanks for sharing, Please continue blogging.

    ReplyDelete
  10. There are lots of information about latest technology and how to get trained in them, like Hadoop Training Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Hadoop Training in Chennai). By the way you are running a great blog. Thanks for sharing this (Salesforce Training in Chennai).

    ReplyDelete
  11. Hi, PHP is a server-side general purpose scripting language used for web development, which is used in almost all personal blogs. It is a very easy to understand language that can be easily learnt with a proper PHP Training in Chennai. You can join a course at FITA, where the best PHP Training in Chennai is taken, and excel as a web developer.

    ReplyDelete
  12. This comment has been removed by the author.

    ReplyDelete
  13. Anonymous6:07 pm

    This comment has been removed by a blog administrator.

    ReplyDelete
  14. This is amazing step by step guide!

    http://www.tekclasses.com/

    ReplyDelete
  15. Great stuff!
    http://www.tekclasses.com/

    ReplyDelete
  16. Very Clear Step By Step Guide, Thank You for sharing an important information http://www.vaysinfotech.com/

    ReplyDelete
  17. Nice post.Thanks for sharing.Watch this Video to learn basics of SQL.
    Its only for beginners.Learn basics of SQL in 1 Hour.
    SQL for Beginners.Try this.....

    ReplyDelete
  18. Excellent Post thanks for sharing PL/SQL Online Training

    ReplyDelete
  19. It’s too informative blog and I am getting conglomerations of info’s. Thanks for sharing; I would like to see your updates regularly so keep blogging. If anyone looking car just get here
    Regards,
    sas training in Chennai|sas course in Chennai|sas institutes in Chennai

    ReplyDelete
  20. Valuable information thanks for sharing Oracle PL/SQl Online Training

    ReplyDelete
  21. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
    Informatica Training In Chennai
    Hadoop Training In Chennai
    Oracle Training In Chennai
    Pega Training In Chennai
    Hadoop Training In Chennai

    ReplyDelete
  22. Excellant content thanks for sharing the unique information and keep posting.
    Android Training in Chennai | android courses in Chennai | FITA Velachery | FITA Training

    ReplyDelete
  23. very nice article.Thanks for sharing the post...!
    Java Online Training

    ReplyDelete
  24. logon to http://informatica.vpweb.in for remote / online Informatica server access

    ReplyDelete
  25. This comment has been removed by the author.

    ReplyDelete

  26. Excellant content thanks for sharing the unique information and keep posting.

    Bank Exam Questions and Answers

    Group Exam Questions and Answers

    ReplyDelete
  27. Anonymous2:18 pm

    Thank you for sharing this useful story.
    I think your shared information is helpful to me and who are want update their knowledge, who want to started their career with Oracle 12c PL/SQL Online Training.

    ReplyDelete
  28. Informatica
    Very valuable information provided, folks will be getting good knowledge Informatica online training

    ReplyDelete
  29. Anonymous3:58 pm

    Thank for sharing this useful information;
    It is very useful to me and who are wanted to learn or update their knowledge on Oracle PL/SQL through Oracle PL/SQL online training or offline training.

    ReplyDelete
  30. Anonymous4:14 pm

    it's realy nice. it's realy helpful for sql bigginers.keep it your sharing.more talking to Website for school uk

    ReplyDelete
  31. really awesome post for sql basic learners thank you for sharing useful content...

    http://www.erptree.com/course/oracle-apps-training-in-hyderabad/

    http://www.erptree.com/course/oracle-fusion-training-in-hyderabad/

    ReplyDelete
  32. very good and informative article,Thanks for sharing informative article its very useful to me..

    http://erptree.com/course/oracle-fusion-hcm-online-training-in-san-francisco-bay-area-california-usa/

    ReplyDelete
  33. Thanks for sharing the very useful info about Oracle and please keep updating........

    ReplyDelete
  34. Thanks for sharing the very useful info about SQL Server and please keep updating........

    ReplyDelete
  35. I found your blog has very interesting topics,thanks for sharing such an interesting information with us.
    http://www.calfre.com/Hyderabad/Oracle-Fusion-SCM-Online-Training/listing

    ReplyDelete
  36. In these, an article using now automation tools learning beginner very useful. If you want to be learning from automation testing tools Jenkins, Maven, Ant any more automation tool reached and visit there for below web page.If you want to be learning from automation testing tools reached and visit there for below web page.
    Selenium Training in Chennai

    ReplyDelete
  37. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    SEO Company in India

    ReplyDelete
  38. You have explained Well about oracle architecture. Great effort. Keep updating.
    Oracle dba training syllabus | Oracle dba certification cost in chennai

    ReplyDelete
  39. Srihitha Technologies is a vast experienced online training center in Hyderabad, India since 2006, with highly qualified and real time experienced faculties, offers Angular JS online training with real time project scenarios.

    In the course training we are covering What is AngularJS?, Understanding the MVC Pattern, How AngularJS Works, Scope, Filters, Directives, Routing, Dependence Injection, Service, Security, Events, Module, Testing, Debugging AngularJs, Project etc…

    For more details please contact: 9885144200.

    Mail id: srihithaonlinetraining@gmail.com

    For course content and more details please visit http://www.srihithatechnologies.com/angularjs.php

    ReplyDelete
  40. great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome. Oracle Training in bangalore

    ReplyDelete
  41. nice one thanks for sharing this informative blog about Oracle
    Oracle Training

    ReplyDelete
  42. This comment has been removed by the author.

    ReplyDelete
  43. This is also good channel for SQL and Ax erp you can subscribe and watch in enhance your knowledge.

    https://www.youtube.com/user/sksingh1980

    http://daynamicsaxaptatutorials.blogspot.com/

    ReplyDelete
  44. This comment has been removed by the author.

    ReplyDelete
  45. This really has covered a great insight on Pl Sql . I found myself lucky to visit your page and came across this insightful read on Pl sql tutorial. Please allow me to share similar work on Pl sql training course :-


    https://www.youtube.com/watch?v=phvcwekT9ZA

    ReplyDelete
  46. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.

    Hadoop Training in Chennai

    ReplyDelete

  47. Nice Blog post. Thanks for sharing great information. keep posting..

    SAP Online Training Courses

    ReplyDelete
  48. Your website have a valuable information,thanks for sharing information.
    Oracle SQL and PL/SQL Training in Hyderabad

    ReplyDelete
  49. Informative blog and it was up to the point describing the information very effectively. Thanks to blog author for wonderful and informative post

    Final Year Robotics Projects Chennai | Final Year Vlsi Projects Chennai.

    ReplyDelete
  50. Thank you for very nice information.
    It is very useful to me and who are searching for

    Final Year Java Project Centres Chennai | Final Year Dotnet Project Centres Chennai.

    ReplyDelete
  51. Nice article thanks for given this information. I hope it useful to many People.
    Oracle Training in Delhi

    ReplyDelete
  52. Nice information is on your blog, Thanks for sharing such a nice article.
    Oracle SQL and PL/SQL Training in Hyderabad

    ReplyDelete
  53. That's a great article. Thanks for sharing your knowledge...
    oracle course in chennai

    ReplyDelete
  54. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    python training in chennai

    python training in bangalore

    python online training

    python training in pune

    python training in chennai

    python training in bangalore

    python training in tambaram

    ReplyDelete
  55. Anonymous5:45 pm

    Thanks for the informative article. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.
    Oracle training in pune
    Oracle Online Training
    Oracle training in Bangalore
    Oracle training in Sholingaanallur
    Oracle training in marathahalli

    ReplyDelete
  56. Thanks for your post. This is amazing, and interesting. Keep Updating more information. Thank you!!
    DevOps Online Training

    ReplyDelete
  57. Thank you for providing the helpful information. This blog is very useful for beginners.
    DevOps Online Training

    ReplyDelete
  58. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
    nebosh course in chennai

    ReplyDelete
  59. Nice post. I learned some new information. Thanks for sharing.

    Education
    Technology

    ReplyDelete
  60. I really liked your post, thanks for sharing!!

    http://datastageonlinetrainings.com/

    ReplyDelete
  61. Thanks first of all for the useful info.
    the idea in this article is quite different and innovative please update more.
    Best Java Training in Bangalore
    Java Training in Perambur
    Java Courses in Saidapet
    Java Training in Kelambakkam

    ReplyDelete
  62. The post is written in very a good manner and it entails many useful information for me. I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept.
    Java training in Bangalore | Java training in Electronic city

    Java training in Bangalore | Java training in Marathahalli

    Java training in Bangalore | Java training in Btm layout

    Java training in Bangalore | Java training in Jaya nagar

    ReplyDelete
  63. Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    Java training in Bangalore | Java training in Marathahalli

    Java training in Bangalore | Java training in Btm layout

    Java training in Bangalore |Java training in Rajaji nagar

    ReplyDelete
  64. Hi, Very informative Blog. very Clear explanation about Oracle
    Regards,
    Machine Learning Course In Chennai

    ReplyDelete
  65. This is an best post. It is Really very informative concept.I like it and help me to development very well.Thanks alot for this brief explanation and very nice information.BEST SQl Server Training In Hyderabad

    ReplyDelete
  66. After seeing your article I want to say that the presentation is very good and also a well-written article with some very good information which is very useful for the readers....thanks for sharing it and do share more posts like this.
    Data Science course in rajaji nagar
    Data Science with Python course in chenni
    Data Science course in electronic city
    Data Science course in USA
    Data science course in pune | Data Science Training institute in Pune
    Data science course in bangalore

    ReplyDelete
  67. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 
    Authorized iphone service center in Chennai | iphone service center in chennai | Mobile service center in chennai | Authorized iphone service center in Chennai | iphone service center in chennai

    ReplyDelete
  68. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    Informatica training in Chennai | Informatica training in Chennai

    ReplyDelete

  69. thank your valuable content.we are very thankful to you.one of the recommanded blog.which is very useful to new learners and professionals.content is very useful for hadoop learners
    Best Spring Classroom Training Institute
    Best Devops Classroom Training Institute
    Best Corejava Classroom Training Institute
    Best Oracle Classroom Training Institute

    ReplyDelete
  70. Just found your post by searching on the Google, I am Impressed and Learned Lot of new thing from your post. I am new to blogging and always try to learn new skill as I believe that blogging is the full time job for learning new things day by day.

    Best Spring Classroom Training Institute
    Best Devops Classroom Training Institute
    Best Corejava Classroom Training Institute
    Best Oracle Classroom Training Institute
    Best Oracle Classroom Training Institute

    ReplyDelete
  71. Thanks For Sharing The Information The Information Shared Is Very Valuable Please Keep Updating Us Time Just Went On Reading The article Oracle Online Course

    ReplyDelete
  72. Thank your valuable content.we are very thankful to you.one of the recommended blog.which is very useful to new learners and professionals.content is very useful for hadoop learners


    Best Spring Online Training Institute
    Best Devops Online Training Institute
    Best Datascience Online Training Institute
    Best Oracle Online Training Institute
    Best Sql server Online Training Institute


    ReplyDelete
  73. Thanks For Sharing The Information The Information Shared Is Very Valuable Please Keep Updating Us Time Just Went On Reading The article sql server Online Course

    ReplyDelete
  74. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Worthful Sql server tutorial. Appreciate a lot for taking up the pain to write such a quality content on SQL server tutorial. Just now I watched this similar sql server Online Course

    ReplyDelete
  75. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Worthful Sql server tutorial. Appreciate a lot for taking up the pain to write such a quality content on SQL server tutorial. Just now I watched this similar sql server Online Course

    ReplyDelete
  76. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Worthful Sql server tutorial. Appreciate a lot for taking up the pain to write such a quality content on SQL server tutorial. Just now I watched this similar sql server Online Course

    ReplyDelete
  77. Attend The Python Training in Bangalore From ExcelR. Practical Python Training in Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Python Training in Bangalore.

    ReplyDelete

  78. Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live.
    angularjs training in chennai | angularjs course in chennai | angularjs training institute in chennai | angularjs training institutes in chennai

    ReplyDelete
  79. Thanks for sharing such a wonderful Post with us. I learnt alot from your post. I am appreciating from you to you will share more
    information about it. Please keep sharing. Thanks Alot
    Acer laptop Service Center in Ameerpet, Hyderabad.
    Best Laptop Service Center in Ameerpet, Hyderabad.

    ReplyDelete
  80. Great blog informative posts

    Piping Design Engineering course is a job oriented diploma course. Sanjary academy provide best piping design course in Hyderabad, India with job assistance.
    best Piping Design Course
    piping design course with placement
    pipe stress analysis course in hyderabad
    piping engineering course in hyderabad
    piping stress analysis course
    best Piping Design institute
    best institute of Piping Design Course in India

    ReplyDelete
  81. such a great word which you use in your article and article is amazing knowledge. thank you for sharing it.

    Softgen Infotech is the Best SAP S4 HANA Training in Bangalore located in BTM Layout, Bangalore providing quality training with Realtime Trainers and 100% Job Assistance.

    ReplyDelete
  82. Nice article I was really impressed by seeing this blog, it was very interesting and it is very useful for me.
    SQL Azure Online Training
    Azure SQL Training
    SQL Azure Training

    ReplyDelete
  83. Great Article
    Cloud Computing Projects


    Networking Projects

    Final Year Projects for CSE


    JavaScript Training in Chennai

    JavaScript Training in Chennai

    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete
  84. Quality content is the key to attract readers. And you provide just that. Good work. Read more about python course in chennai from our website.

    ReplyDelete
  85. i am thankful for your help on adding extra content for this
    oracle training in chennai

    ReplyDelete
  86. Here is the site(bcomexamresult.in) where you get all Bcom Exam Results. This site helps to clear your all query.
    DDUGU BCOM 2nd Year Result 2020
    BA 3rd year Result
    BA Result 2020

    ReplyDelete
  87. Aptron Noida provides real-time and placement focused Oracle Training Course in Noida. Our oracle database course includes basic to advanced level and our oracle course is designed to get placement in good MNC companies in Noida as quickly as once you complete the oracle courses in Noida with placement.

    ReplyDelete
  88. Thanks for sharing this post. Your post is really very helpful for everyone..
    Oracle Performance Tuning

    ReplyDelete
  89. Want to do Want to do Data Science Course in Chennai with Certification Exam? Catch the best features of Data Science training courses with Infycle Technologies, the best Data Science Training & Placement institutes in and around Chennai. Infycle offers the best hands-on training to the students with the revised curriculum to enhance their knowledge. In addition to the Certification & Training, Infycle offers placement classes for personality tests, interview preparation, and mock interviews for clearing the interviews with the best records. To have all it in your hands, dial 7504633633 for a free demo from the experts.

    ReplyDelete
  90. Thanks for sharing. we are gery thankful to you. one of the recommended blog.

    Java developer job available in Chennai

    ReplyDelete
  91. This post is so interactive and informative.keep update more information…
    Spoken English Classes in Anna Nagar
    Spoken English Classes in Chennai

    ReplyDelete
  92. Looking for real-time training institue.Get details now may if share this link visit
    ss training in hyderabad
    adf training in hyderabad

    ReplyDelete
  93. Thank you for sharing such a really admire your post. Your post is great! . micronutrients fertilizer for plants

    ReplyDelete
  94. If you are still looking QuickBooks Help you should start by dialing at
    QuickBooks customer service +1 267-773-4333 s and talk to a support agent

    ReplyDelete
  95. QuickBooks customer service is best options If you are looking for a QuickBooks Customer Service you can contact us at. QuickBooks customer service : +1 602-362-8345

    ReplyDelete
  96. https://g.page/r/CZwUuN5qHBsEEBM/Thanks for sharing this wonderful post ! QuickBooks is the perfect software for small business owners and entrepreneurs. If you have any query about QuickBooks software you can go through Our QuickBooks Customer Service +18555588273

    ReplyDelete
  97. This comment has been removed by the author.

    ReplyDelete
  98. I appreciate you sharing this content.
    angular js online institute in Hyderabad

    ReplyDelete