How to create a database using DBCA and delete a created data on Windows 10(Hindi)?
Hello Friends,
This videos shows How to Create New Database using Database Configuration Assistant(DBCA) and delete a created data on Windows 10?
I explain step by step creation in this video.Now I want to give brief information about PGA and SGA which I not discussed in the video.
PGA full form is Program Global Area.s a private memory region that contains the data and control information for a server process. Only a server process can access the PGA. Oracle Database reads and writes information in the PGA on behalf of the server process. An example of such information is the run-time area of a cursor. Each time a cursor is executed, a new run-time area is created for that cursor in the PGA memory region of the server process executing that cursor.
SGA full form is System Global Area.It is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background processes. Examples of data stored in the SGA include cached data blocks and shared SQL areas.
if you still have question or query you can ask me on below comment section or you can follow me on twitter and ask any thing on twitter.
If you like my video Please Like,Share and Subscriber to my channel.Don't forget to press bell icon to get video in your inbox.
Thanks for Watching......
Facebook Link: / riteshvshah11
Twitter Link: / riteshtechnow