SQL

I have put in my best efforts to ensure the task's completion meets the expected standards and aligns with the desired outcomes. I have also attached any relevant documents, reports, or deliverables associated with the task for your convenience.

Should you require any further information or clarification regarding the completed task, please do not hesitate to reach out to me. I am available to discuss any aspects in more detail or provide additional support as needed.

Thank you for entrusting me with this task. I look forward to your feedback and guidance on the next steps or any revisions required.


SELECT (SELECT COUNT(*) FROM USER_TABLES) AS table_count, (SELECT COUNT(*) FROM USER_VIEWS) AS view_count, (SELECT COUNT(*) FROM USER_INDEXES) AS index_count FROM DUAL;

SELECT 
    (SELECT COUNT(*) FROM USER_TABLES) AS table_count,
    (SELECT COUNT(*) FROM USER_VIEWS) AS view_count,
    (SELECT COUNT(*) FROM USER_INDEXES) AS index_count,
    (SELECT COUNT(*) FROM USER_TABLES) + (SELECT COUNT(*) FROM USER_VIEWS) + (SELECT COUNT(*) FROM USER_INDEXES) AS total_count
FROM DUAL;


#!/bin/bash

# Oracle Database Parameters Comparison Script

# Specify the Oracle home directory
ORACLE_HOME="/path/to/oracle/home"

# Specify the database instances to compare
DB_INSTANCES=("instance1" "instance2" "instance3")

# Specify the output file
OUTPUT_FILE="parameter_comparison.txt"

# Function to compare the parameters of two instances
compare_parameters() {
  local instance1=$1
  local instance2=$2
  
  echo "Comparing parameters for $instance1 and $instance2"
  
  # Get the parameter values for instance1
  $ORACLE_HOME/bin/sqlplus -S "/ as sysdba" <<EOF >instance1_parameters.txt
  set pagesize 0
  set feedback off
  select name, value from v\$parameter;
  exit;
EOF

  # Get the parameter values for instance2
  $ORACLE_HOME/bin/sqlplus -S "/ as sysdba" <<EOF >instance2_parameters.txt
  set pagesize 0
  set feedback off
  select name, value from v\$parameter;
  exit;
EOF

  # Compare the parameter values
  diff -u instance1_parameters.txt instance2_parameters.txt >>$OUTPUT_FILE
}

# Main script

# Clear the output file
echo >$OUTPUT_FILE

# Compare parameters for each pair of instances
for ((i = 0; i < ${#DB_INSTANCES[@]}; i++)); do
  for ((j = i + 1; j < ${#DB_INSTANCES[@]}; j++)); do
    compare_parameters "${DB_INSTANCES[$i]}" "${DB_INSTANCES[$j]}"
  done
done

# Clean up temporary files
rm instance1_parameters.txt instance2_parameters.txt

echo "Parameter comparison completed. Results are stored in $OUTPUT_FILE"


stages:
  - check_vm_status

check_vm_status:
  stage: check_vm_status
  image: mcr.microsoft.com/azure-cli:latest
  script:
    - az login --service-principal -u $AZURE_CLIENT_ID -p $AZURE_CLIENT_SECRET --tenant $AZURE_TENANT_ID
    - vm_status=$(az vm show --resource-group your-resource-group --name your-vm-name --query powerState -o tsv)
    - echo "VM status: $vm_status"



Comments

Post a Comment

Popular posts from this blog

Java Practice Questions MCQ

1. What is the output? class point1 { static void a (int x, int y) { this.x=x; //non-static variable this cannot be referenced from a static context this.y=y; System.out.println(x+ “,”+y); } } class point { public static void main (String[] args) { point1 pp=new point1(); pp.a(4,3); } } a. 4 ,3 b. 3 ,4 c. Compile Error d. None of the above ------------------------------------------------------------------------------------------------------- 2. Local variables cannot be declared as final.(True / False) .... False ----------------------------------------------------------------------------------------------------- 3. What is the output? class A { A(int x, int y) { this.x=x; this.y=y; } A() { this(2,3); } public static void main(String[] args) { A a1 = new A(); System.out.println(“x=”+a1.x+”,y=”+a1.y); // cannot find symbol x and y } } a. x=2 y=3 b. x=-1...
Read more

Linux Assignments - Practise

UNIX ASSIGNMENTS: Day 1 Concept : Basic commands in UNIX, Filters, Pipes Objective : Participant will be able to: ·          Execute Basic Unix commands ·          Implement the concepts of Pipes and Filters ·          Work with vi editor Problems: Section 1: 1.        List all the files and sub directories of the directory /bin. 2.        List all the files including hidden files in your current directory. 3.        List all the files starting with letter ‘r’ in your current directory. 4.        List all the files having three characters in their names, from your current directory. 5.        List all the files with extension ‘.doc’ in your current directory. 6.     ...
Read more

HackerRank Introduction Challenges - Java

HackerRank Introduction Challenges - Java Welcome to Java! Problem Statement Welcome to the world of Java! Just print "Hello World." and "Hello Java." in two separate lines to complete this challenge. The code stub in the editor already creates the main function and solution class. All you have to do is copy and paste the following lines inside the main function. System.out.println("Hello World."); System.out.println("Hello Java."); Sample Output Hello World. Hello Java. Download Code Here Java Stdin and Stdout 1 Problem Statement In most of the Hackerrank challenges, you need to read input from stdin (standard input) and write your output in stdout (standard output). One way to take input from stdin is to use Scanner class and reading from System.in. You can write your output to stdout simply using System.out.printf function. In this problem you need to read 3 integers from stdin and print them ...
Read more