Diposting kali ini, saya akan membagikan cara mengatasi session limit user, jika ada user mengalami session limit dikarenakan ada batasan untuk login database atau karenakan koneksi tidak stabil sehingga harus berapa kali untuk reconnect, standarnya user dapat login ke database hanya dua kali, untuk memastikan kita cek PROFILE USER limit loginnya berapa kali langkah pertama kita cek profile kita masuk ke mana seperti step 1 berikut :
SELECT PROFILE FROM DBA_USERS WHERE USERNAME = 'USERNAME_DB';
USERNAME_DB di sesuaikan dengan user yang temen-teman gunakan, akan tetapi jika ingin melihat all user WHERE USERNAME = ‘USERNAME_DB’ dihilangkan
Yang saya tampilkan ini, hanya melihat user profile yang saya gunakan
Terlihat hasil eksekusi bahwa user yang saya cek masuk ke PROFILE : NONAPPS_PROFILE, selanjutnya kita akan mengecek berapa limit user login untuk profle : NONAPPS_PROFILE
SELECT PROFILE, LIMIT FROM DBA_PROFILES WHERE RESOURCE_NAME = 'SESSIONS_PER_USER'
Terlihat bahwa profile NONAPPS_PROFILE hanya memiliki session limit user 2 kali.
Selanjutnya apakah kita akan melakukan KILL SESSION USER atau penambahkan LIMIT PROFILEnya. Di sini saya akan mencoba melakukan KILL SESSION USER dan penambahkan LIMIT PROFILE NONAPPS_PROFILE
Untuk penambahkan LIMIT PROFILE tambahkan script berikut :
ALTER PROFILE (profile_name) LIMIT SESSIONS_PER_USER (number);
Contoh : kita merubah profile name dan number sesuai kebutuhan, number di sini adalah jumlah session limit yang akan di tambahkan pada profile tersebut, sedangkan profile name adalah profile yang akan kita rubah limit sessionnya. di sini profile name yang saya gunakan adalah NONAPPS_PROFILE dengan menambahkan limit session user 5.
ALTER PROFILE NONAPPS_PROFILE LIMIT SESSIONS_PER_USER 5;
Jika ingin LIMIT SESSION UNLIMITED tambahkan script berikut :
ALTER PROFILE (profile name) LIMIT SESSIONS_PER_USER UNLIMITED;
Contoh : Di sini saya kan membuat profile name NONAPPS_PROFILE limit session usernya Unlimited
ALTER PROFILE NONAPPS_PROFILE LIMIT SESSIONS_PER_USER UNLIMITED;
Sedangkan untuk melakukan KILL SESSION USER bisa gunakan script berikut :
BEGIN FOR r IN (select sid,serial# from v$session where username='user') LOOP EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid || ',' || r.serial# || ''' immediate'; END LOOP; END;
User di ganti dengan nama user yang akan di lakukan KILL SESSION USER, di sini user yang akan di kill session nya adalah ACEPSOPIAN,Script di atas akan melakukan kill session user atas nama ACEPSOPIAN, Contohnya sebagai berikut :
BEGIN FOR r IN (select sid,serial# from v$session where username='ACEPSOPIAN') LOOP EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid || ',' || r.serial# || ''' immediate'; END LOOP; END;
Sekian tutorial kali ini Happy codding 🙂
I regard something genuinely special in this website .
thank you, hope my blog is useful
Of course, what a splendid blog and educative posts, I surely will bookmark your blog.Best Regards!
Thank you for visiting the blog
Can I just say what a relief to find someone who actually knows what theyre talking about on the internet. You definitely know how to bring an issue to light and make it important. More people need to read this and understand this side of the story. I cant believe youre not more popular because you definitely have the gift.
Thank you for visiting the blog
ngdmkapec,If you have any struggle to download KineMaster for PC just visit this site.
Thank you for visiting, hopefully it will be useful
xekmdkphnu,Thanks for ones marvelous posting! I actually enjoyed reading it, you will be a great author.I will always bookmark your blog and will zguptliql,come back from now on. I want to encourage that you continue your great writing, have a nice afternoon!
Thank you for visiting, hopefully it will be useful
ldmmosh,A fascinating discussion is definitely worth comment. I do think that you ought to publish more on this topic, it may not be a taboo dwyantikwv,subject but generally folks don’t talk about such subjects. To the next! All the best!!
Thank you for visiting, hopefully it will be useful
horqkoyt,Some really nice stuff on this website, I enjoy it.
Thank you for visiting, hopefully it will be useful
sfzljpidrs Yeezy Boost 350,Some really nice stuff on this website, I enjoy it.
Thank you for visiting, hopefully it will be useful
qrwspncks,If you are going for best contents like I do, just go to see this web page daily because it offers quality contents, thanks!
Thank you for visiting, hopefully it will be useful
gvjicwh,Very helpful and best artical information Thanks For sharing.
Thank you for visiting, hopefully it will be useful
fquncxfko,Your blog was informative and valuable to me. Thanks for sharing.
thank you, don’t forget to visit my blog again
awnbjtlehf Yeezy Boost,Very informative useful, infect very precise and to the point. I’m a student a Business Education and surfing things on Google and found your website and found it very informative.
thank you, don’t forget to visit my blog again
lridmgt,Thanks a lot for providing us with this recipe of Cranberry Brisket. I’ve been wanting to make this for a long time but I couldn’t find the right recipe. Thanks to your help here, I can now make this dish easily.
thank you, don’t forget to visit my blog again
tcvouciyaqp Yeezy Boost 350,Very helpful and best artical information Thanks For sharing.
thank you, don’t forget to visit my blog again
doudxgdm,This website truly has alll of the information and facts I wanted about this subject and didn?t know who to ask.
thank you, don’t forget to visit my blog again
A limited release will go down this Friday, April 19th online and at their NYC store for $390.
Thank you for visiting, hopefully it will be useful
“Because of the poor economic performance in Europe, we are facing a slowdown in global economic growth,” Kudlow said in an interview with Bloomberg Television. But unlike the White House, at the policy meeting in March, the Fed did not conclude that the global economic slowdown meant that the bank should start cutting interest rates.
Thank you for visiting, hopefully it will be useful
Otherwise, Political inaction and continued infighting may have serious consequences.”
Thank you for visiting, hopefully it will be useful
Thank you for visiting, hopefully it will be useful