srvctl command is an important tool to manage the Oracle database in the RAC environment and Oracle restart env(Single node env with ASM). This can be used to stop, start, find status and other things in the cluster or the server.Let’s review those command srvctl commands srvctl is a utility in $ORACLE_HOME/bin and it has […]
how to check db size in oracle
We often need to find the database size for space allocation and future growth, Let’s see how to check db size in oracle for Both the Non-CDB and CDB databases How to check db size in oracle for Non-CDB Database Here is the query which can be used to find the database size select ‘Total […]
How to access oracle cloud compute instance(Linux/Window)
We can have both Linux and Windows compute instances in the Oracle Cloud. Let’s learn about how to login to both the Linux and Window compute instance/how to access oracle cloud compute instance Linux Compute Instance We first need to make sure, we have the public IP associated with the Compute instance and security list […]
size of schema in oracle
A schema in Oracle consists of tables, index, Log segments, Lob Index, table partition and index partition. The schema size in oracle depends on the size of all these objects. Let’s check how to find the size of schema in oracle How to find the segment_type for a particular schema select segment_type,count(*) from dba_segments where […]
Pagination in Oracle
Pagination is common in Web-based applications. The user inputs a set of criteria, which runs a query and then lets the user click the Previous and Next buttons to page through the result set. To achieve this paging functionality, the application needs to be able to get a certain set of rows from the Database […]
rownum in Oracle
Here in this post, we will talk about the ROWNUM keyword in Oracle What is ROWNUM It is a pseudo column (not a real column) that is available in a query. ROWNUM is assigned the numbers 1, 2, 3, 4, … N, where N is the number of rows for the first, second, third…n records […]