Oracle Redo and archive log files are two important pieces in Oracle database environment. They both are used for recovering the database from failure.I would be explaining two important command alter system switch logfile and alter system archive log current about them ,their difference and what they command actually performs in the oracle database ALTER SYSTEM …
alter system switch logfile v/s archive log current Read More »
One can’t grant direct access V$session as v$session is a synonym. Same is true for v$instance In fact this is true for all the v$ views are they are all synonym’s SQL> GRANT SELECT ON v$session TO test_user; grant select on v$session to test_user * ERROR at line 1: ORA-02030: can only select from fixed …
How to grant access to v$ views (v$session ,v$instance) Read More »
We often need to get the definition of the table, index, views, etc in Oracle to replicate the structure in another Oracle database. Oracle has a very useful command to find the metadata definition of the various structures. This command is very useful in extracting the metadata of any objects like table, index, views, Materialized …
Get Table,View, Materialized View, Package, Index Definition in Oracle Read More »
Print/echo statement (1) Like python or other programming language, Print in PHP or echo in PHP does the same job i.e printing the statement on the screen Example <?php print “This is php script”; echo ” This is php script”; ?> This is php script This is php script So it is obvious from the …
A Physical Standby database relies on the continuous application of archive logs from a Primary Database to be in sync with it. In Oracle Database versions prior to 10g in the event of an archive log gone missing or corrupt, you had to rebuild the standby database from scratch. From 10g you can use an …
how to recover standby database from a missing archive log Read More »
What is virtualization Virtualization is the process of creating multiple virtual machines /operating system from one physical hardware box Each machine works independently from each other and have their own Operating system Each Virtual machine has the Virtual hardware Virtual CPU – it is the physical CPU which is allocated to virtual machine Virtual storage …
Virtualization : Types of Hypervisor, Benefits Read More »
