DeltaDBA
DeltaDBA
  • 70
  • 20 205

Video

Connect to oracle database using SQL developer
zhlédnutí 65Před 14 dny
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Use password non interactively in shell script for oracle database
zhlédnutí 99Před měsícem
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Listener creation and configuration in oracle
zhlédnutí 79Před měsícem
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
How To Check High CPU Usage and diagnosis For Oracle Database
zhlédnutí 759Před měsícem
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Manage Autotask For Oracle Maintenance Window
zhlédnutí 80Před měsícem
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Kill processes consuming high resource and spawing multilple sub processes in Oracle
zhlédnutí 256Před měsícem
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Finding patterns from file Shell Script
zhlédnutí 56Před 2 měsíci
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Common Oracle files to house keep and update locate db
zhlédnutí 196Před 2 měsíci
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Convert multiple raw 10046 trace to tkprof format oracle
zhlédnutí 52Před 2 měsíci
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Environmental Variable Basics for Oracle
zhlédnutí 74Před 2 měsíci
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Different Shells In Linux For Oracle DBA's
zhlédnutí 43Před 2 měsíci
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
AWK Pattern Search In Shell Script Linux
zhlédnutí 34Před 2 měsíci
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Checking Oracle Server Status
zhlédnutí 73Před 2 měsíci
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Kill Particular Session In Oracle
zhlédnutí 93Před 2 měsíci
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Identify The Type of Software Edition In Oracle Database
zhlédnutí 57Před 2 měsíci
Identify The Type of Software Edition In Oracle Database
Connect to Oracle Database Client Using Bash Shell Script
zhlédnutí 192Před 2 měsíci
Connect to Oracle Database Client Using Bash Shell Script
Calculate time taken for job to complete
zhlédnutí 46Před 2 měsíci
Calculate time taken for job to complete
Identify MY Current Session In Oracle Database
zhlédnutí 103Před 2 měsíci
Identify MY Current Session In Oracle Database
Find spid Of A Session In Oracle
zhlédnutí 58Před 2 měsíci
Find spid Of A Session In Oracle
How To Take Care Of Inactive Sessions In Oracle
zhlédnutí 542Před 3 měsíci
How To Take Care Of Inactive Sessions In Oracle
How To Get Average Response Time Of SQL In Oracle Database
zhlédnutí 70Před 3 měsíci
How To Get Average Response Time Of SQL In Oracle Database
To Kill Sessions In Oracle Project scenario
zhlédnutí 86Před 3 měsíci
To Kill Sessions In Oracle Project scenario
Oracle Database Session Monitoring
zhlédnutí 661Před 3 měsíci
Oracle Database Session Monitoring
Identify diagnostic trace files In Oracle Database
zhlédnutí 77Před 3 měsíci
Identify diagnostic trace files In Oracle Database
Oracle Blocking session Scenario
zhlédnutí 112Před 3 měsíci
Oracle Blocking session Scenario
Table refresh activity In Oracle
zhlédnutí 140Před 3 měsíci
Table refresh activity In Oracle
Check SQL Command Type In Oracle Database
zhlédnutí 53Před 3 měsíci
Check SQL Command Type In Oracle Database
How To Change Database Name In Oracle
zhlédnutí 88Před 3 měsíci
How To Change Database Name In Oracle
ORA-1000 And Open cursors In Oracle
zhlédnutí 56Před 3 měsíci
ORA-1000 And Open cursors In Oracle

Komentáře

  • @utkaarshshivhare5724
    @utkaarshshivhare5724 Před 15 dny

    Bro helped me get attendance 😂

  • @madhuhyd1221
    @madhuhyd1221 Před 24 dny

    Nice explanation tq brother Please do more videos.

  • @user-pt4rx1hn1y
    @user-pt4rx1hn1y Před měsícem

    Can you Give me ur number please

  • @srideva6577
    @srideva6577 Před měsícem

    Excellent.. Thank you ❤

  • @gopalkrishnachodisetti3056

    Hello sir, Good day! I have a few questions for you. Can you please give me an answers.

    • @exhydra369
      @exhydra369 Před měsícem

      yes pls let me know the questions you have?

    • @gopalkrishnachodisetti3056
      @gopalkrishnachodisetti3056 Před měsícem

      @@exhydra369 1. How to run the DB's with 4 hours gap in primary DB and secondary DB. 2. How to add checkpoint and if you add checkpoint what happened? 3. What is the use of red log files in standby, what the role plays in standby. 4. In prod temp. File is added but it will not replicted in standby, why? 5. My redo is over size then DB size what happen?

  • @farimmereki2669
    @farimmereki2669 Před 2 měsíci

    great info

  • @dotagamer5925
    @dotagamer5925 Před 2 měsíci

    Is INNER JOIN costly ?? Just curious to know

    • @exhydra369
      @exhydra369 Před 2 měsíci

      There is no concrete answer for this but it depends and quite complex. Generally, joining tables needs more work than independent table which means more cost. Also it depends on the number of records in driving and driven table, how the data is distributed in these tables, fragmentations, purity of statistics etc..

  • @bgmblast1432
    @bgmblast1432 Před 2 lety

    sir when i restrore database it showing no backup

  • @KareemAbdo555
    @KareemAbdo555 Před 3 lety

    can you help me fix these errors for Oracle 19c & sql server 19 when I go through the database configuration and creation wizard for Primavera 20, it reaches the step of creating pubuser and privuser in both cases, oracle and msql server, then i get error messages but different from each other, in Oracle I get error run sql script orppm_creat_users.sql ORA-65096 while, In sql server database, i get creating the sql server tablespaces for p6 ppm error exectue sql script ssppm_itit_db.sql Can you help me solve this problem?

  • @VirajMane-zx1wo
    @VirajMane-zx1wo Před 3 lety

    Its working super

  • @aayushsingh1378
    @aayushsingh1378 Před 3 lety

    Nice background Music😎

  • @skabdulazeez1818
    @skabdulazeez1818 Před 3 lety

    Nothing is visible ... Better change the video

  • @exhydra369
    @exhydra369 Před 5 lety

    just try this and startup again ps -ef|grep ora|awk '{print $2}'|xargs -i kill -9 {} note that if you are in production dont do this as you are killing the key background processes because of memory contention.If still issue persist then try increasing the shm to bigger value or modify your /etc/sysctl.conf parameters to oracle recommended kernel values.Thanks!!

  • @simbasmsmms5756
    @simbasmsmms5756 Před 5 lety

    Hi friend, Thanks for this video, it has solved my error. I am getting error as below could you please help me in below. ORA-01081: cannot start already-running ORACLE - shut it down first