What is Oracle Partitioned Table? Partitioning divides a table, index, or index-organized table into smaller components. Each component is called a partition (or subpartition for composite partitioned objects). Every partition has a unique name, and may optionally have individual storage characteristics: examples include compression, or being stored in different tablespaces. A well-designed partitioning strategy can …
Oracle partitioned table Read More »
About Linux Operating system 1. It was originally developed by Linus Torvalds. It name is mixture of Linus and Unix2.Linux Operating system is modular in design. We have user space and Kernel3. Kernel interacts with Hardware and schedule and use resource like CPU, Memory, storage and network on behalf of application. 4. Application runs in …
We have to practice the sql statement to become well versed with syntax, restrictions and expression. Oracle Express Edition for windows is a good environment to do practice on your laptop or Desktop . I am going to provide you the step by step installation guide for that. Step by Step Oracle Express Edition Installation …
How to Install Oracle Express Edition for SQL Practice Read More »
ORA-00054: resource busy and acquire with NOWAIT specified is a common error seen in Oracle Database Reference: Oracle documentation This generally happens when you try to execute a DDL on the table which is locked by transaction .It also happens if select for update statement is executed with NOWAIT option Example SQL> alter table emp add …
ORA-00054: resource busy and acquire with NOWAIT specified Read More »
Here is useful 33 Oracle RMAN interview questions . This is good for both junior level and experienced professional . I hope you like this compilation on Oracle RMAN interview questions. Question 1 What is RMAN?AnswerRMAN stands for recovery manager.it is a utility that can manage your entire Oracle backup and recovery activities. Question 2 …
In this section we will be defining the terms like Database time(DB time in oracle ), Active session ,elapsed time and Average active session DB Time Database Time, or DB Time, is defined by Oracle as the total time by foreground sessions executing database calls. This includes CPU time, IO time, and non-idle wait time. …
What is DB time ,DB cpu Average Active sessions, Active session in oracle Read More »
