oracle – Page 8 – DBA Notes

Oracle

Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS

DBMS_STATS package was introduced in Oracle 8i and used to gather Database,table,Schema,dictionary and fixed object statistic in Oracle database. Statistic of objects should be up…

Oracle

convert seconds into mins hours in Oracle

Bulent Soylu March 14, 2022 oracle

Oracle

Oracle Standby Redo Logs vs Online Redo Logs:

Bulent Soylu March 14, 2022 online redo logs oracle standby redo logs

Redo Logs Conceptually, Oracle Redo Logs are a collection of Redo records. Redo records are a group of change vectors. Each change vector denotes a…

MySQL Oracle Postgres

DBA Interview Questions

Bulent Soylu March 11, 2022 interview questions LDAP oracle ssl sso

1-Explain the security practices such as LDAP SSL SSO and certificate management LDAP: Lightweight Directory Access Protocol–LDAP is a tool for extracting and editing data…

Oracle

Drop Objects in Oracle

Bulent Soylu February 15, 2022 drop procedure drop table oracle

The best and most efficient way is to catch the “table not found” exception: this avoids the overhead of checking if the table exists twice;…

Oracle

SQL Developer autocommit on/off

Bulent Soylu February 1, 2022 autocommit oracle sql developer

Click the checkbox to turn it on. Here’s what the setting does: Value Impact Checked Autocommit is on. SQL statements that change data will have…

Oracle

Resource limit of sessions and processes in Oracle

Bulent Soylu January 26, 2022 oracle procsesses sessions

Check the resource limit of session and processes in Oracle With help of V$RESOURCE_LIMIT view, we can see the current utilization and MAX utilization of…