V$PASSWORDFILE_INFO V$PASSWORDFILE_INFO provides information about the database password file. select * from v$passwordfile_info; show parameter remote_login_passwordfile; Remote_login_passwordfile Parameter and it’s use Remote_login_passwordfile specifies whether Oracle checks… Read More »REMOTE_LOGIN_PASSWORDFILE
A database link is a connection from the Oracle database to another remote database. The remote database can be an Oracle Database or any ODBC-compliant… Read More »Oracle database link
The HAVING clause is an optional clause of the SELECT statement. It is used to filter groups of rows returned by the GROUP BY clause. This is why the HAVING clause is usually… Read More »HAVING Clause
Overview of Oracle Data Pump Oracle Data Pump technology enables very high-speed movement of data and metadata from one database to another. An understanding of… Read More »Oracle Data Pump
Oracle Managed Files (OMF) Oracle Managed Files (OMF) simplifies the creation of databases as Oracle does all OS operations and file naming. It has several… Read More »Oracle Managed Files
What is pfile in oracle? In Oracle, a “pfile” is a text-based configuration file that contains initialization parameters for an Oracle instance. The term “pfile”… Read More »SFILE PFILE – Kaj je to ?
Introduction to Oracle MINUS Operator The Oracle MINUS operator compares two queries and returns distinct rows from the first query that are not output by the second query. In other words,… Read More »Minus operator
Using SET TRANSACTION to begin a transaction is optional. A new transaction begins implicitly with the first DML statement that you execute after you make… Read More »Transactions
Posted from: https://oracledbwr.com/oracle-process-monitor-background-process/#:~:text=Process%20Monitor%20process%20is%20background,Slave%20Process%20slaves%20(CLnn). Which two statements are true about the PMON background process? (Choose two.)
Basic Table Compression If you are not familiar with Basic Table Compression, then some important points to know about Basic Table Compression are that it… Read More »Oracle Advanced Compression