AI Techno Sys

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

Skip the Carousel

1 2 3 4 5

11 months ago | [YT] | 0

AI Techno Sys

For online IT Training Videos

youtube.com/@HumSubTechno?sub_confirmation=1

Skip the Carousel

1 2 3

11 months ago | [YT] | 6

AI Techno Sys

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...

1 year ago | [YT] | 0

AI Techno Sys

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='*';

1 year ago | [YT] | 0

AI Techno Sys

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 year ago | [YT] | 1