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 […]
What is PGA The Program Global Area (PGA) is a private memory region that contains the data and control information
What are base tables? When and how they will get created? Ans:-Are read-only tables(Data Dictionary Tables) that hold information about
EXPDP IMPDP Data Pump Interview Questions | CloudDBA clouddba.in / Oracle Interview Questions / EXPDP IMPDP Data Pump Interview Preparation
Generic DBA Interview Questions – Oracle Listener & Tablespace | CloudDBA clouddba.in / Oracle Interview Questions / Generic DBA Interview
Clustering Factor and it’s effect on non-assm and assm tablespace. The clustering factor is a measure of the ordernesss of
A. B-Tree Indexes I have discussed more details in the below blog. http://clouddba.co/index-internal-oracle-using-simple-test-case/ B.Invisible Indexes Deciding which columns to index
Index internal oracle using simple test case First of all I will create a table with char(1000) so that in
How histogram can affect query plan change hence performance. 1.Let me create a test case.I am loading the table with
1.Let us create a test case first:- oracle@TST:TESTDB1[/home/oracle]$ sqlplus c##test/test C##TEST@TESTDB1> create table mytst1 as select * from dba_objects; Table