dba-tips.blogspot.com
Database Administration TipsA blog about oracle database administration tips, implementations, scripts and Linux script.
http://dba-tips.blogspot.com/
A blog about oracle database administration tips, implementations, scripts and Linux script.
http://dba-tips.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Sunday
LOAD TIME
0.3 seconds
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
4
SITE IP
172.217.11.33
LOAD TIME
0.344 sec
SCORE
6.2
Database Administration Tips | dba-tips.blogspot.com Reviews
https://dba-tips.blogspot.com
A blog about oracle database administration tips, implementations, scripts and Linux script.
dba-tips.blogspot.com
Database Administration Tips: November 2012
http://dba-tips.blogspot.com/2012_11_01_archive.html
If you can't explain it simply, you don't understand it well enough." Albert Einstein. Tuesday, November 27, 2012. All About Statistics In Oracle. In this post I'll try to summarize all sorts of statistics in Oracle, I strongly recommend reading the full article, as it contains information you may find it valuable in understanding Oracle statistics. Database Schema Table Index Statistics. SQL EXEC DBMS STATS.GATHER DATABASE STATS(. ESTIMATE PERCENT= 100,METHOD OPT= 'FOR ALL. CASCADE = TRUE,. Degree = 4,.
Database Administration Tips: September 2013
http://dba-tips.blogspot.com/2013_09_01_archive.html
If you can't explain it simply, you don't understand it well enough." Albert Einstein. Sunday, September 22, 2013. Upgrade RAC 11.2.0.1 to 11.2.0.3 (Part IV RAC Database Upgrade from 11.2.0.1 to 11.2.03). I've installed the Linux OS and prepared the shared filesystem (ISCSI configuration and OCFS2). I've prepared the Linux OS for the RAC installation, installed 11.2.0.3 Grid Infrastructure and Database software. Start upgrading the new primary DB from 11.2.0.1 to 11.2.0.3. Terminate managed recovery mode...
Database Administration Tips: Switch Database to RMAN Image Copy Backup and Switch It Back
http://dba-tips.blogspot.com/2011/11/switch-database-to-rman-copy-backup-and.html
If you can't explain it simply, you don't understand it well enough." Albert Einstein. Sunday, November 13, 2011. Switch Database to RMAN Image Copy Backup and Switch It Back. Considering RMAN image copy backup for your production databases in your backup strategy is a very helpful approach during hardware failure scenarios. Why to consider RMAN image backups in your backup strategy:. When to switch to the image backup:. 1- You lost a disk contains one datafile or more. RMAN backup as copy database;.
Database Administration Tips: September 2014
http://dba-tips.blogspot.com/2014_09_01_archive.html
If you can't explain it simply, you don't understand it well enough." Albert Einstein. Monday, September 22, 2014. Script To Ease The Job Of Gathering Statistics On Schema Or Table. Today I'll share a shell script to gather statistics on a full schema or table, hoping it will help in saving your time, you can download it from this link:. Https:/ www.dropbox.com/s/ce7ssbn6sygwmed/gather stats.sh? This script is part of the database administration bundle I shared in an earlier post:. In case you provided t...
Database Administration Tips: March 2013
http://dba-tips.blogspot.com/2013_03_01_archive.html
If you can't explain it simply, you don't understand it well enough." Albert Einstein. Thursday, March 28, 2013. The difference between granting direct privileges to a user and granting same privileges within a role. When granting a role to a user the user have to re-login to get use of that role. When granting a privilege to a user the user can use it immediately. NO need to re-login. Roles doesn't give the granted user the right to create objects based on the role given to him. SQL create role hr1;.
TOTAL PAGES IN THIS WEBSITE
19
DBA - Conception et réalisation de bancs de test sur-mesure
A propos de DBA. Systèmes de test sur-mesure. CONCEPTION and RÉALISATION DE BANCS DE TEST. CARACTÉRISATION, TEST FONCTIONNEL, ENDURANCE, EXPERTISE, SIMULATION D ÉQUIPEMENTS . DBA – Partenaire de l’ingénierie. Qualité, fiabilité et conformité de vos produits sont des enjeux majeurs pour votre entreprise et son image de marque. Expert reconnu dans le domaine du test depuis plus de 20 ans, DBA vous accompagne dans vos projets, de la conception à la réalisation d’un banc de test personnalisé et sur-mesure.
Thoughts Of A DBA
Thoughts Of A DBA. Monday, 25 August 2014. Recover Data from Damaged/Corrupted/Inconsistent/Offline/Truncated/Dropped Table While the Database is Offline. In this post I'll discuss one of these tools, Oracle Database Unloader (ODU). Http:/ www.oracleodu.com/en/download. Full version: It restores all data only if you got the license file from the support [Not Free]. Upload the downloaded file to the server and then extract it:. Gunzip odu 433 linux x86.tar.gz. Tar xvf odu 433 linux x86.tar. Chown u x odu.
Oracle DBA Tip and Trick
Oracle DBA Tip and Trick. Database Administrator Tips and Tricks applying with every version of Oracle (i.e. Oracle 8i/9i/10g/11g) including PL/SQL, Trigger, Store Procedure. Also provide how to install Oracle on Linux platform and MS Windows platform and Oracle Error and The Solution to solve them. This is default featured slide 1 title. Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions. This is default featured slide 2 title. Wednesday, April 8, 2015.
Database Administration Tips
If you can't explain it simply, you don't understand it well enough." Albert Einstein. Wednesday, February 28, 2018. DBA Bundle V4.1 Released. DBA Bundle V4.1 is now released with the following new scripts. Backup ctrl spf AWR.sh. Backup Controlfile as (Trace/RMAN BKP), Backup SPFILE and Generate AWR for full day This script can be scheduled in the crontab to run once a day. Script options/variables must be modified to match your environment. New Starting from V4.1. Kill long running queries.sh. It will ...
focus on oracle----------------- by oracle dba Tony | tony dba oracle
Focus on oracle—————– by oracle dba Tony. 概括一下故障处理应该叫 数据库datafile offline drop后的恢复. 操作系统linux redhat Oracle 11.2.0.2单节点. SQL alter database datafile ‘/oradata1/* *LOG02.dbf’ offline drop;. Rm rf /oradata1/* * LOG02.dbf. Select file name file id, tablespace name status from dba data files where file id=24;/oradata1/* * *LOG02.dbf 24 WEBINTAKE RECOVE. Dba在删除数据文件的时候用的命令是错误的，offline drop offline drop并不会删除数据文件，只会讲数据文件置为一种离线状态，如果数据没有归档的话，这是一种风险很大的操作。 Thu Mar 13 14:06:21 2014. Oracle rac在安装过程中可能会遇到各种问题，有一些是能提前准...
DBA Trading
Press enter to begin your search. We are a Miami based company with more than 30 years of experience in video, photography, audio, and projection technologies. We count with the technical and professional support from worldwide leading manufactures. To offer high technology solutions and quality products efficiently while providing the best brand support and world class customer service. 8475 NW 29 TH Street Doral, FL, 33122. Telephone: 1.305.702.7985.
Wirtschaftsprüfer, Steuerberater Wels
PARTNER TREUHAND Salzburg GmbH. Springe direkt zum Inhalt. Springe direkt zum Menü. PARTNER TREUHAND Salzburg GmbH Steuerberatungsgesellschaft. Spenden- / Sponsoring- / Inseratanfragen. Für Vermieter / Immobilien. Für Banken and Versicherungen. Rechts- u. Steuerinfos. Entscheidend am Start - Information und Beratung. Seit vielen Jahren begleiten wir innovative Menschen auf ihrem erfolgreichen Weg. Rechnen Sie mit uns. Profitieren Sie von unserem Serviceangebot. Was Sie wissen sollten. Was wir unseren Kun...
Tricks for Oracle DBA's
Tricks for Oracle DBA's. In this blog I will publish short tips that can make life easier to the crowd of Oracle DBA's around the world (at least in my intention). Wednesday, March 14, 2012. How to recover a database with missing archived redo logs. Have you ever faced the situation where you need to recover a database with missing archives, and because of that Oracle won't let you open the database? Here is an excelent article. Explaining what to do. Sunday, March 11, 2012. ASM has two diskgroups: FLASH.
