• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

srvctl commands

August 8, 2022 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

how to check db size in oracle

August 7, 2022 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

How to access oracle cloud compute instance(Linux/Window)

August 5, 2022 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle cloud

size of schema in oracle

July 31, 2022 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Database

Pagination in Oracle

July 30, 2022 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle, Oracle Sql

rownum in Oracle

July 30, 2022 by techgoeasy Leave a Comment

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 […]

Filed Under: Oracle

  • Page 1
  • Page 2
  • Page 3
  • …
  • Page 109
  • Next Page »

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • srvctl commands
  • how to check db size in oracle
  • How to access oracle cloud compute instance(Linux/Window)
  • size of schema in oracle
  • Pagination in Oracle

Copyright © 2022 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us