HI EXPERT, I HAVE THE ORACLE 10G SERVER, I HAVE ADDED RAM IN IT,NOW THE TOTAL RAM IS 8 GB AND THE OS IS WINDOWS SERVER 2003 32- BIT ENTERPRISE EDITION.
STILL THE PERFORMANCE OF THE DATABASE IS SAME,SO I WANT TO INCREASE THE SGA_MAX_SIZE.SO PLEASE LET ME KNOW THE WAY TO INCREASE IT.
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…