![DeltaDBA](/img/default-banner.jpg)
- 69
- 19 407
DeltaDBA
เข้าร่วมเมื่อ 9 พ.ย. 2018
This Channel Offers technical knowledge on technologies both practically and theoretically with scenarios
Connect to oracle database using SQL developer
Please subscribe the channel for more technical videos!
For more articles on different technology, follow my blog
www.alphaoragroup.com
For more articles on different technology, follow my blog
www.alphaoragroup.com
มุมมอง: 33
วีดีโอ
Use password non interactively in shell script for oracle database
มุมมอง 9121 วันที่ผ่านมา
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
มุมมอง 74หลายเดือนก่อน
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
มุมมอง 590หลายเดือนก่อน
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
มุมมอง 72หลายเดือนก่อน
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
มุมมอง 221หลายเดือนก่อน
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
มุมมอง 51หลายเดือนก่อน
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
มุมมอง 185หลายเดือนก่อน
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
มุมมอง 48หลายเดือนก่อน
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
มุมมอง 70หลายเดือนก่อน
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
มุมมอง 42หลายเดือนก่อน
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
มุมมอง 342 หลายเดือนก่อน
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Checking Oracle Server Status
มุมมอง 702 หลายเดือนก่อน
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
มุมมอง 872 หลายเดือนก่อน
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
มุมมอง 562 หลายเดือนก่อน
Please subscribe the channel for more technical videos! For more articles on different technology, follow my blog www.alphaoragroup.com
Connect to Oracle Database Client Using Bash Shell Script
มุมมอง 1652 หลายเดือนก่อน
Connect to Oracle Database Client Using Bash Shell Script
Calculate time taken for job to complete
มุมมอง 432 หลายเดือนก่อน
Calculate time taken for job to complete
Identify MY Current Session In Oracle Database
มุมมอง 972 หลายเดือนก่อน
Identify MY Current Session In Oracle Database
How To Take Care Of Inactive Sessions In Oracle
มุมมอง 4662 หลายเดือนก่อน
How To Take Care Of Inactive Sessions In Oracle
How To Get Average Response Time Of SQL In Oracle Database
มุมมอง 672 หลายเดือนก่อน
How To Get Average Response Time Of SQL In Oracle Database
To Kill Sessions In Oracle Project scenario
มุมมอง 862 หลายเดือนก่อน
To Kill Sessions In Oracle Project scenario
Identify diagnostic trace files In Oracle Database
มุมมอง 762 หลายเดือนก่อน
Identify diagnostic trace files In Oracle Database
Check SQL Command Type In Oracle Database
มุมมอง 522 หลายเดือนก่อน
Check SQL Command Type In Oracle Database
Add or Remove comments In Shell Script
มุมมอง 223 หลายเดือนก่อน
Add or Remove comments In Shell Script
Bro helped me get attendance 😂
Nice explanation tq brother Please do more videos.
Can you Give me ur number please
Excellent.. Thank you ❤
Hello sir, Good day! I have a few questions for you. Can you please give me an answers.
yes pls let me know the questions you have?
@@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?
great info
Glad it was helpful!
Is INNER JOIN costly ?? Just curious to know
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..
sir when i restrore database it showing no backup
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?
Its working super
Nice;
Nice background Music😎
Nothing is visible ... Better change the video
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!!
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