Welcoem to posts!!
in the future - u will be able to do some more stuff here,,,!! like pat catgirl- i mean um yeah... for now u can only see others's posts :c
Please share your major issues in comments about below databases then I will share the Resolutions
1-PostgreSql
2-MS Sql Server
3-Oracle
4-My SQL
youtube.com/@HumSubTechno?sub_confirmation=1
0 - 2
Online Technology Trainings for beginners to advanced
1- Wordpress
2- Postgresql
3- Python
4- Oracle database
5- MS Sql server database
6- My sql databases
For Internship and trainings
---------------
Email
-------
humsubtechno@gmail.com
YouTube:youtube.com/@HumSubTechno?sub_confirmation=1
Educational: www.youtube.com/playlist?list...
PostgreSQL: www.youtube.com/playlist?list...
Oracle Database Cluster: www.youtube.com/playlist?list...
Python: www.youtube.com/playlist?list...
Oracle Database Administration: www.youtube.com/playlist?list...
Learn English with Fun: www.youtube.com/playlist?list...
Disaster Recovery: www.youtube.com/playlist?list...
Motivation: www.youtube.com/playlist?list...
ERP Software: www.youtube.com/playlist?list...
Educational: www.youtube.com/playlist?list...
0 - 0
Error:
CKPT (OSPID : 383463) waits for event 'rdbms ipc reply' for 223 secs.
Checking: ( Top Wait Event of CKPT)
select event, state, count(*) from v$session_wait group by event, state order by 3 desc;
SELECT filename, status, bytes FROM v$block_change_tracking;
Solution:
alter system set "_bct_buffer_allocation_max"=1073741824 scope=both sid='*';
alter system set "_bct_public_dba_buffer_maxsize"=1073741824 scope=both sid='*';
alter system set "_bct_public_dba_buffer_size"=1073741824 scope=both sid='*';
0 - 0
Cache Fusion to smoothly move data blocks between these instances’ buffers across the cluster connection. If one instance reads a data block from the disk and another instance needs the same block, it’s faster to grab it from the instance that already has it in its memory (SGA) than reading from the disk again.
1 - 0
Online Learning, E- Solutions, Career Development, Online Services, ERP Software, Point of Sales