The value for parameter ESTIMATE is either BLOCKS (default) or STATISTICS. BLOCKS: The estimated space used is calculated by multiplying the number of database blocks used by the target objects with the appropriate block sizes. It is the least accurate because of: The table was created with a much bigger initial extent size than was needed for […]
All posts by Skant Gupta
ESTIMATE_ONLY in Oracle Expdp
This parameter is useful when you wanted get the approximate size of the dump file. Suppose you have only limited space available in the disk and if you wanted to check whether your dump will be fit into the available space then you can use this parameter to check or estimate the size of the […]
Running Oracle on Docker
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. If you want to know about Basic about Docker in the Oracle Hi everyone, here in a very brief post I will show you how to upload Oracle in a Docker container. Following the DevOps wave, this week I’m doing a course and knowing […]
Storage Volumes and File System Layout in Oracle Cloud
This section provides information about the storage volumes and file system layout of a newly created database deployment on Oracle Database Cloud Service. Compute Cloud Service Storage Volumes When a Database Cloud Service deployment is created using the Oracle Database Cloud Service service level, the following storage volumes are created. Storage Volume Description bits 60 GB volume completely […]
Explain usage of different users in Oracle Cloud
This article provides information about Linux user accounts that are provisioned on Oracle Database Cloud Service. Every Database Cloud Service compute node is provisioned with the following operating system user accounts. Both compute nodes are provisioned with the following operating system user accounts. opc: The system administrator account you use with the sudo command to perform operations that […]
List of other Certification earned
Skant Gupta is certified for: Microsoft Microsoft® Certified Technology Specialist: SQL Server® 2005 Microsoft® Certified Solutions Associate: Office 365 (MCSA) Microsoft® Specialist: Server Virtualization with Windows Server Hyper-V and System Center Specialist Microsoft® Certified Professional IBM IBM Certified Deployment Professional – Tivoli Directory Server V6.1 IBM Certified Associate Developer — Rational Application Developer for WebSphere Software […]
Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials
Hi Readers Finally I’ve successfully passed 1Z0-337, Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials. It was almost more than 2 months that I’ve been preparing for this. The Exam contains 60 questions related to Compute, Container, Networking and Ravello Services. To earn this certification you need to get 70% marks. This was the result of […]
Database Server Components of Exadata X7-2
Database Server Components of Oracle Exadata Database Machine X7-2 Oracle Exadata Database Machine X7-2 database servers include the following components: 2 x 24-core Intel Xeon Platinum 8160 Processors (2.10GHz) 384GB RAM 1.5T (24 x 64GB) with memory expansion kit 4 x 600 GB 10K RPM SAS disks, hot swappable, expandable to 8x Disk controller HBA […]
Oracle Exadata 18c and Database Machine X7-2
Oracle Exadata Database Machine consists of Oracle Database servers, Exadata Storage Servers, and the network components to connect to your network. Oracle Exadata Database Machine is available as a full rack, half rack, quarter rack or eighth rack. The following table lists the components included for each type of Oracle Exadata Database Machine. Components of […]
HOW TO CONVERT SCN TO DATE AND DATE INTO SCN
SQL>select current_scn from v$database; 7705798324 SQL> select timestamp_to_scn(to_timestamp(’24/09/2012 14:24:54′,’DD/MM/YYYY HH24:MI:SS’)) as scn from dual; SCN ———- 7705798324 SQL> SQL> select scn_to_timestamp(7705798324) as timestamp from dual; 24-SEP-12 02.24.52.000000000 PM Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or […]