Change “Value” Column Width for “show parameter” in sqlplus

Posted on by Ahmed Abdel Fattah

If you tried to increase the width of the "VALUE" column, nothing changed: I found that the NAME & Value columns have special names (for type column , it is normal): column NAME_COL_PLUS_SHOW_PARAM format A20column VALUE_COL_PLUS_SHOW_PARAM format A80 Now, it is fine.

تعديلات نظام الدراسة والإمتحانات الجديدة في مصر نتيجة فيروس كورونا

Posted on by Ahmed Abdel Fattah

لكل الناس اللي عندهم أولاد فى مراحل التعليم ما قبل الجامعي و عايزين يفهموا التعديلات اللي تمت علي الدراسة والإمتحانات خلال الأيام القليلة الماضية, يا ريت يسمعوا الفيديو ده اللي أنا عملته بناء علي تصريحات وزير التعليم فقط مع استبعاد أي معلومات من أي مصادر أخري https://www.youtube.com/watch?v=4TWhy1nhWvY

Combining Resource Consumer Groups with Application Modules in #Oracle

Posted on by Ahmed Abdel Fattah

Uwe Hesse

This article contains a complete working example for the Resource Manager on the command line for those of you who can’t use the Enterprise Manager fort it. Believe me, I feel your pain 😉

As a good practice, PL/SQL procedures should be using DBMS_APPLICATION_INFO to mark their modules and actions. Not only for monitoring purpose but also to provide a way to tweak the system if things start going ugly in terms of performance. Here’s where the Resource Manager steps in.

Sessions can be assigned to different consumer groups depending on the module. Say we have an application with certain modules that sometimes consume an awful lot of CPU resources or way too much parallel processes. When the problem surfaces, you may not have enough time to fix the coding because it’s a live production run. The mentioned tweak – if prepared beforehand – may save the day. Let’s look…

View original post 853 more words