Below section I have tried to present all the important features in Oracle Database management
Tracing is an important part of Oracle database tuning. This will help capture all the problem statements and waitevents that are responsible for the slow running of the session. Oracle database has provided has many quickest ways to trace the local session, and other user sessions and format the trace to make readable SQL tracing …
SQL trace, 10046 event in Oracle Read More »
In many cases, DBA needs to log in with another user whose credentials/oracle password are not known, also exporting schema and importing the schema, and preserve the same password. Let’s check out how it works out with alter user identified by values Oracle Database 10G Oracle stores the hash of the username and password is …
Sometimes we might have different OS timezone settings while starting the database. Also, it could be possible that srvctl is using different timezone settings while starting the Database and this will impact the Database timezone used. You can use the below method to find currently used OS timezone for background processes For 11.2 and up:this …
How to see the OS timezone used when the database was started Read More »
Oracle tablespace stores the data in the Oracle database and as the data grows, we often need to add space to the tablespace. We can add space in two ways. we can either resize the existing data file or add the new data file to the tablespace. We will check out adding datafile to tablespace …
Oracle Database administrator has to prepare for the possibility of hardware, software, network, process, or system failure. If such a failure affects the operation of a database system, he must usually recover the database and return to normal operation as quickly as possible.So database recovery is very important for the organization Oracle Database Recovery should …
Oracle Database Recovery various cases and solution Read More »
A shared pool is an important memory structure in Oracle database system global area(SGA) What is Shared Pool in Oracle The shared pool in the Oracle database is the place where Oracle caches the SQL, PL/SQL and dictionary data. Whenever we parse a query, the parsed representation is cached there and it is shared also. Oracle …
Shared Pool in Oracle and Shared pool flush in Oracle database Read More »
