ORA-OCA - DBA-MAN

<style>/*<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-9014620058237107&host=ca-host-pub-1556223355139109" crossorigin="anonymous"></script>

<!-- data-ad-client=ca-pub-9014620058237107 -->

</head><body>*/</style>

ORA-OCA

Managing Database Instances (part 4)

Managing Initialization-Parameter Files Oracle uses initialization-parameter files to store information about initialization parameters use...

Salah Quddomi 8 Mar, 2023

ORA-OCA

Managing Database Instances (part 3)

Oracle Database Metadata An Oracle Database contains two types of metadata views: Data dictionary views Dynamic performance views The SYS us...

Salah Quddomi 8 Mar, 2023

ORA-OCA

Managing Database Instances (part 2)

Shutting Down an Oracle Instance Just as with starting the database, several options as well as a variety of interfaces are available for da...

Salah Quddomi 8 Mar, 2023

ORA-OCA

Managing Database Instances (part 1)

Starting Up an Oracle Instance Two special connection account authorizations are available for startup and shutdown: SYSDBA authorization i...

Salah Quddomi 8 Mar, 2023

ORA-OCA

Oracle Database Architecture (Part 04)

Oracle Storage Structures A-The Physical Structure : The physical storage structures include three types of files (Critical files that make ...

Salah Quddomi 27 Feb, 2023

ORA-OCA

Oracle Database Architecture (Part 03)

Oracle Background Process : A - Required Oracle background processes by the Oracle instance (found in all Oracle instances) : Database Wr...

Salah Quddomi 24 Feb, 2023

ORA-OCA

Oracle Database Architecture (Part 02)

Oracle Instance consists of Oracle’s main memory structure, called the system global area (SGA, also known as shared global area) and severa...

Salah Quddomi 20 Feb, 2023

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/984859869-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY7PZSQ9wNLYLgNZi0-Mm5IvXNbc_g:1732852687253';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d1421508429079680174','//dba-man.blogspot.com/search/label/ORA-OCA?max-results\x3d10','1421508429079680174');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '1421508429079680174', 'title': 'DBA-MAN', 'url': 'https://dba-man.blogspot.com/search/label/ORA-OCA?max-results\x3d10', 'canonicalUrl': 'https://dba-man.blogspot.com/search/label/ORA-OCA?max-results\x3d10', 'homepageUrl': 'https://dba-man.blogspot.com/', 'searchUrl': 'https://dba-man.blogspot.com/search', 'canonicalHomepageUrl': 'https://dba-man.blogspot.com/', 'blogspotFaviconUrl': 'https://dba-man.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22DBA-MAN - Atom\x22 href\x3d\x22https://dba-man.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22DBA-MAN - RSS\x22 href\x3d\x22https://dba-man.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22DBA-MAN - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/1421508429079680174/posts/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-9014620058237107', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/2fafd358a4bcb2b4', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'index', 'searchLabel': 'ORA-OCA', 'pageName': 'ORA-OCA', 'pageTitle': 'DBA-MAN: ORA-OCA', 'metaDescription': 'DBA-MAN It\x27s a Blog Provide Content About Database System Administration Professional Expert like ORACLE , SQL SERVER , MY SQL....etc.'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'DBA-MAN', 'description': 'DBA-MAN It\x27s a Blog Provide Content About Database System Administration Professional Expert like ORACLE , SQL SERVER , MY SQL....etc.', 'url': 'https://dba-man.blogspot.com/search/label/ORA-OCA?max-results\x3d10', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isSearch': true, 'isLabelSearch': true, 'search': {'label': 'ORA-OCA', 'resultsMessage': 'Showing posts with the label ORA-OCA', 'resultsMessageHtml': 'Showing posts with the label \x3cspan class\x3d\x27search-label\x27\x3eORA-OCA\x3c/span\x3e'}}}, {'name': 'widgets', 'data': [{'title': 'Upload Image', 'type': 'Image', 'sectionId': 'upload-image', 'id': 'Image50'}, {'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML50'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList52'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList53'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'before-blog', 'id': 'HTML51'}, {'title': 'Featured Post', 'type': 'FeaturedPost', 'sectionId': 'before-blog', 'id': 'FeaturedPost50', 'postId': '694058078348859941'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'before-post', 'id': 'HTML52'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog50', 'posts': [{'id': '694058078348859941', 'title': ' Managing Database Instances (part 4)', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEg1HGymvCzlRBuJZdedhMWJ4dUuV5CU5L7HvZZ3XOi9kg8FJU-OdJl3zP31AjgVmZfbzcX0qEgVn6NCmHUS3NslPmmkmbk2t6Dl6RSVawvu6kGtSK1KN5g-eO01mdUYsTskfpgEitI2lwxGjpPFhM_CyZ2-RRoJoQqmmh2xRtb4q4_yofi7_ZvWdoCXEw\x3dw640-h336', 'showInlineAds': false}, {'id': '6813945241065498661', 'title': ' Managing Database Instances (part 3)', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdzo8uwGUoAHdxs0cJzc6CdW4PLxXjUI0Fl5LErPP9cemKz8gfKQNkVK9FAwdlSq2syaPZeXx6t6Nw8f5PjdiBE8fe_gP9FsvfkJGBK0p2S6WNyf1KHk4FWCTFRkRPVYGR8TURi-Eq7qyG3Ke4kFJbc-RpX6FtyXURQQ-4p-0dsixSd_ewLsMv6HKdKg/w640-h334/manage_ins01%20-%20BLOG.png', 'showInlineAds': false}, {'id': '4847697027086811168', 'title': ' Managing Database Instances (part 2)', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpCtNgHMbjWr16_iagibnpi1aEH0VokTE0eHxh8oMQdYRQyreO7p4gyH7yaZEMvYP3L2fIE-t6qQQHwV80yg7zvX8D8Pv-AhuRgdNjAXwlwRbWoxlOBdKOBuf1oQGyNhs9zXDD0SacpZMzKEf6GEg9aOQbnxt5qvbwdqUfP-jDLhornEGGN9cVli5o5g/w640-h334/manage_ins01%20-%20BLOG.png', 'showInlineAds': false}, {'id': '4505868981085442670', 'title': ' Managing Database Instances (part 1)', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdmJ8M2a18cOrqGEwHd56SkxqG5Hbs3xQeglL-MHWMcQEtiz9yZSI2IbS9WxHvWn2x8VgdFMUoWJoQKltzX4de8Agwu4ZJ26J7WlgTJWM4mb2A1w12jIcO7oHKvqRcrPdwno6WiasR96QoVq1Ah6VPVteE8Zs8WdGZqvFVN7Zc9-kSTIVXATgGcXltRw/w640-h334/manage_ins01%20-%20BLOG.png', 'showInlineAds': false}, {'id': '9059023028821824435', 'title': 'Oracle Database Architecture (Part 04)', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh20bJ7-KQkHB9Jc2GeFmLE-9t69-tZWdR-x8L-70bbnU3L_kIlWMcZ0wpSN17Oylgh8zVIR_EXZZYkls1NZ0PDblbRq4h0bnPL3V7YXVMCoLt6OOp_qXF2HCWYFMYGHoApNU3WeSCPZ_INDQhoUCy6yeQJ0d0kS8qwT8pdahi0i9yJywwvvaHc4qsi7Q/w400-h225/db_storage.jpg', 'showInlineAds': false}, {'id': '4959570576910546719', 'title': 'Oracle Database Architecture (Part 03)', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikD6TAWR-bHl2ApgKp6WwR0VlLaWiRAvayZ-EmaJJeWsEbSoTzvw0BbTrVvcU63jE9S22ySmrCA8mLVP8qL8nHbwp94ngCAuQHFr_bmQFDoMdntM7Gp2F1uTKsxalhzdnYU38ijml8L1tvxnXqlmHlS7l2C8hD7-QsD55lwNWMGAWSjB2PB4z903be3A/w400-h278/db_bg.jpg', 'showInlineAds': false}, {'id': '8346216903816550430', 'title': 'Oracle Database Architecture (Part 02)', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiJuV0WJEt9StIUu0CnpJXmUihiUt6L4HJXHzn0LtGIETKrTd0l-R1K-n9wnjKefWnaEhP-TW6ChTCfNr5-fhrMPZ1PbhAGazb_YQdOimRNn_laEb-1I8lJhqSY9KSlt6Bzwi_r6Fbl_FeKa3Wzx0E53Ckmm0gzR1a_OjKs2YIPPlXvyghBPfxmDcY7w/w400-h219/db_memory.jpg', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': 'Posted by'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Labels:'}]}], 'allBylineItems': [{'name': 'author', 'label': 'Posted by'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}, {'name': 'labels', 'label': 'Labels:'}]}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML61'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML62'}, {'title': '#You may also like', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML63'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML64'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML65'}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label50'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts50', 'posts': []}, {'title': 'Hashtag', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label51'}, {'title': '#Recent Post', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML66'}, {'title': '#Advertisement', 'type': 'HTML', 'sectionId': 'sidebar-sticky', 'id': 'HTML54'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML55'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList50'}, {'title': 'Follow Us', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList51'}, {'title': 'Newsletter', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML58'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML56'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML57'}]}]);
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image50', 'upload-image', document.getElementById('Image50'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML50', 'header-main', document.getElementById('HTML50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList52', 'header-main', document.getElementById('LinkList52'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList53', 'header-main', document.getElementById('LinkList53'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML51', 'before-blog', document.getElementById('HTML51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost50', 'before-blog', document.getElementById('FeaturedPost50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML52', 'before-post', document.getElementById('HTML52'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog50', 'blog-post', document.getElementById('Blog50'), {'cmtInteractionsEnabled': false, 'navMessage': 'Showing posts with label \x3cb\x3eORA-OCA\x3c/b\x3e. \x3ca href\x3d\x22https://dba-man.blogspot.com/\x22\x3eShow all posts\x3c/a\x3e', 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2646514562-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML61', 'ads-post', document.getElementById('HTML61'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML62', 'ads-post', document.getElementById('HTML62'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML63', 'ads-post', document.getElementById('HTML63'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML64', 'ads-post', document.getElementById('HTML64'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML65', 'ads-post', document.getElementById('HTML65'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label50', 'sidebar-static', document.getElementById('Label50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts50', 'sidebar-static', document.getElementById('PopularPosts50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label51', 'sidebar-static', document.getElementById('Label51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML66', 'sidebar-static', document.getElementById('HTML66'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML54', 'sidebar-sticky', document.getElementById('HTML54'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML55', 'footer-widget', document.getElementById('HTML55'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList50', 'footer-widget', document.getElementById('LinkList50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList51', 'footer-widget', document.getElementById('LinkList51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML58', 'footer-widget', document.getElementById('HTML58'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML56', 'copyright', document.getElementById('HTML56'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML57', 'jet-options', document.getElementById('HTML57'), {}, 'displayModeFull'));
</script>
</body>*/</style>