Implementing Interval Partition with Enable Row Movement In this article , we will learn how to implement interval partition with enable row movement. Table Creation with interval partition (without interval Row Movement. Create user SYS>>grant dba to ajay identified by ajay; Grant succeeded. Now create… Read More
Online Segment Shrink A segment is a logical storage structure that contains data structure (segment type) of database objects. A segment is a set (unordered) of extents. A segment and all its extents are stored in one tablespace. From Oracle Database 10g, we can use the segment shrinking capability to reclaim unused… Read More
Oracle Grid Infrastructure Service The Oracle Grid Infrastructure for a standalone server is the Oracle software that provides system support for an Oracle database including volume management, file system, and automatic restart capabilities. If you plan to use Oracle Restart or Oracle Automatic Storage Management… Read More
Introduction to Oracle RAC Environment What is Cluster ? A cluster in computer science is a set of computing nodes that work together and can be loosely viewed as a single system. In other words A cluster consists of multiple interconnected servers that appear to end users… Read More
Generate DDL for Tables. In this article , we will see Generating DDL for tables in various methods. Generating DDL is much easier using Plsql Package Plsql Package : DBMS_METADATA.GET_DDL Method 1 : The below script will help you to take DDL only for a… Read More
SQL92_SECURITY Oracle Security Audit: Q: How to improve security level for DML transactions?. Ans: By setting the SQL92_SECURITY parameter we can improve the security level for DML transactions. The configuration option SQL92_SECURITY specifies whether table-level SELECT privileges are required to execute an update or… Read More
PERFORMING RMAN CLONING ON DIFFERENT SERVERS In this article we will implement RMAN Cloning on different servers. Server 1 : PRIMARY Ip Address : 192.168.0.101 Instance name : Primary Database Name : Primary Server 2 : Clone server Ip Address : 192.168.0.102 Instance name : clone_pr… Read More
Salesforce Development SNO ARTICLE LINK DESCRIPTION TECHNOLOGY 1 https://www.ktexperts.com/introduction-to-salesforce/ Introduction to slaesforce Salesforce Thanks for browsing we will upload more….
There is no excerpt because this is a protected post.
TOP SQL’s In this article,we will get notified for TOP SQL’s ORDERED BY ELAPSED TIME Step 1 : Create temporary tables to store TOP SQL’s SYS>>CREATE TABLE dbmon.TOP_ELAPSEDTIME_SQLIDS ( SQL_ID VARCHAR2(20 CHAR), LASTMODIFIEDDATE DATE DEFAULT SYSDATE NOT NULL ); Another table to store ALL SQL’s. SYS>>CREATE… Read More