Today in this post, I will explain how to rebuild the oracle tables or move the different types of oracle tables using the “alter table move” command. we may want to rebuild the table for various reasons like fragmentation removal, moving to a different tablespace, etc. General Steps for rebuilding the Oracle table is Rebuild […]
How to rebuild the table in oracle using alter table move Read More »
We often get confused between CPU vs Core Vs Socket and How to find that in Windows. Here is my attempt at explaining those terms and how we can find them in Windows Physical CPU It is the physical Processor on the server. Each CPU is assigned to one socket Core Each Physical CPU consist
CPU vs Core Vs Socket Read More »
In this post, we will discuss the Difference between v$system_parameter and v$parameter and other parameter view available in Oracle database. Lets first start with the definition of each of them V$PARAMETERIt displays the information about initialization parameters that are currently in effect for the session. V$SYSTEM_PARAMETERis the view which shows instance level parameters (and these are
Difference between v$system_parameter and v$parameter Read More »
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 »
