Sarat 1) What are pre-checks you do before doing point in time recovery? 2) There is no previous level zero backup available, Can we take a Level 1 backup? 3) My database have 500+ datafiles, In that I lost 89 files. How you will identify which files to recover? 4) Can you explain what are internal mechanism of Transportable tablespace […]
Heman Sahi 1. Your RMAN backup triggered, you deleted snapshot controlfile at backend, what will happen to your running backup ? 2. what happens internally when we issue ‘ RESYNC CATELOG’ for recovery catelog ? 3. You enabled Block change tracking and then immediately performed level 1 backup, will BCT be used ? 4. Your RMAN backup triggered, you added […]
I referred some reference from my favorite Tim Hall blog (ORACLE_BASE) A.Basic of optimizer statistics: – The optimizer cost model relies on statistics collected about the objects involved in a query, and the database and host where the query runs. Statistics are critical to the optimizer’s ability to pick the best execution plan for a SQL statement. Object What influences […]
Thanks Akhil Mohan. Debasis Maity: 1.Why controlfile and redolog file multiplexed? Control file : A control file is a small binary file that records the physical structure of the database and includes: The database name. Names and locations of associated datafiles and online redo log files. The timestamp of the database creation. The current log sequence number. Checkpoint information. Oracle […]
Author:-https://www.linkedin.com/in/maheshsrikakula/ Oracle License Cost Calculation basics How to enable/disable oracle license features at Binary Level
OMS Server: Where runs the Enterprise Manager Middleware Client Server: Where we’re going to install the agent 1.Pre-requisites setup to be done in Client Server Create directory where agent will be installed in Client Server In Client,You need to create a directory or mount point as /u01/oemcc Install telnet in Client Server yum install telnet -y Test if the server […]
Answer Credit:- https://www.linkedin.com/in/skantali/ https://www.linkedin.com/in/hemant-shahi-59921762/ How we can execute PLSQL without any privilege to change it What are the default user created when Oracle is installed ? Can you create password less user in Oracle ? If yes how ? How we can see the procedure /package body with out having privilege to execute it How we can create password file […]
What is PGA The Program Global Area (PGA) is a private memory region that contains the data and control information for a server process. Only a server process can access the PGA. Oracle Database reads and writes information in the PGA on behalf of the server process. An example of such information is the run-time area of a cursor. Each […]
What are base tables? When and how they will get created? Ans:-Are read-only tables(Data Dictionary Tables) that hold information about the database. Base tables are own by SYS. When and how they will get created? They get created when the database is built. https://docs.oracle.com/cd/B19306_01/server.102/b14220/datadict.htm Why to execute catproc.sql script? Ans:-Used to create and recreate database internal views/procedures/packagess. Primarily used after […]