dbatips.wordpress.com
DBA advice | Oracle mastermind at work!Oracle mastermind at work!
http://dbatips.wordpress.com/
Oracle mastermind at work!
http://dbatips.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
0.3 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
12
SSL
EXTERNAL LINKS
0
SITE IP
192.0.78.13
LOAD TIME
0.301 sec
SCORE
6.2
DBA advice | Oracle mastermind at work! | dbatips.wordpress.com Reviews
https://dbatips.wordpress.com
Oracle mastermind at work!
dbatips.wordpress.com
CREATE 10g Database on windows Platform | DBA advice
https://dbatips.wordpress.com/2007/02/27/create-10g-database-on-windows-platform
Oracle mastermind at work! CREATE 10g Database on windows Platform. February 27, 2007 in database. Run CMD then set following variables. Create the Oracle Windows services. Oradim -new -sid TST -intpwd password -startmode auto. Pfile C: Oracle Product 10.2.0 Database initTST.ora. Create the Oracle Listener-Service with the Net Configuration Assistant. 4 Create Init file in $ORACLE HOME database directory. 5 Create the server parameter file. CREATE SPFILE FROM PFILE;. USER SYS IDENTIFIED BY password.
How to Create outline | DBA advice
https://dbatips.wordpress.com/2007/02/15/how-to-create-outline
Oracle mastermind at work! How to Create outline. February 15, 2007 in database. When the optimizer chooses to use a bad execution plan for a SQL, a hint can be used to force the SQL to use right execution plan. This is not possible for the third party applications that can’t be changed. In that case, an outline can be used to force the SQL to use right execution plan. How to create outline. Add hint to the SQL statement and check explain plan. CREATE OR REPLACE OUTLINE KP 1 ORG ON. From XXX, YYY. How to...
Impact of Fragmentation on Robustness and Performance of Oracle Database | DBA advice
https://dbatips.wordpress.com/2007/02/10/impact-of-fragmentation-on-robustness-and-performance-of-oracle-database
Oracle mastermind at work! Impact of Fragmentation on Robustness and Performance of Oracle Database. February 10, 2007 in database. Fragmentation of database is a situation where there are many scattered pieces of storage in a database that are too small to be used properly and efficiently. It results in wasted space, which can impact performance and even cause database failure and in effect cause application downtime. Fragmentation Impact on Performance:. Fragmentation Impact on Robustness:. Return an e...
February | 2007 | DBA advice
https://dbatips.wordpress.com/2007/02
Oracle mastermind at work! You are currently browsing the monthly archive for February 2007. Issues with Oracle 10gR2 Precompiler Installation. February 27, 2007 in database. Oracle 10gR2 Precompiler Installation. The following outlines the steps required to ensure that the. Have been successfully installed:. Select same $ORACLE HOME. Choose ‘Custom’ option. From ‘Available Product Components’ screen select ‘Oracle Programmer 10.2.0.1.0’. Oracle 10gR2 Compilation and Relinking. Ld: 0706-005 Cannot find o...
Exchange columns data using Create Table as Select for large tables | DBA advice
https://dbatips.wordpress.com/2007/02/13/6
Oracle mastermind at work! Exchange columns data using Create Table as Select for large tables. February 13, 2007 in database. Instead of using update of columns you can use a script below to exchange the data of two columns that will generate a less of redo logs and will not fail due to undo space. CREATE TABLE xxx temp. Select /* parallel(xxx,8)*/. Oracle 10g Five Important INIT.ora Parameters. How to Create and Alter Oracle Tablespace. How to Gather and Manage stats using DBMS STATS. My other blog site.
TOTAL PAGES IN THIS WEBSITE
12
Yet another DBA blog
Yet another DBA blog. This blog is to share my Oracle experiences and learning’s. It's also to rumble about my feelings on various oracle related stuff. Tuesday, August 30, 2011. Invisible Indexes in Oracle 11g. Always wanted this – the ability to create an index on production without impacting the queries being fired by application but at the same time test the impact an index creation can cause. Invisible indexes are useful alternative to making an index unusable or to drop it. A new column “VISI...
DB Tidbits
Monday, April 4, 2011. Extended Events to Capture Errors;. Hi Extended Events were introduced in SQL Server 2008, I just started learning about it, Jonathan Kehayias has an excellent white paper on Extended Events White Paper. He has also blogged about it extensively. Create an Event session named CaptureErrors we are looking for errors between 10 and 20 in severity. I am using a file target. Also capturing sql text, along with the database id, host computer etc. CREATE EVENT SESSION CaptureErrors. METAD...
Dbatik.net
Welkom bij DBatik.net. Ik ben Deasy, Ik kom uit Indonesie en woon tegenwoordig in Zwolle. Mijn passie is Batik. Om me in batik te verdiepen heb Ik in September 2009 een "BatikTocht" rond Java gemaakt. Batik vind je in verschillende vormen terug in de cultuur, het is een kunstvorm die je als kleding, schilderijen of versieringen van verschillende gebruiksvoorwerpen terug kunt vinden. Batik is cruciaal voor Indonesische mensen. Het aanbrengen van de was kan op verschillende manieren:. Een soort pen waar op...
Wood Bats, Maple Bats, Ash Bats - D-Bat, Inc.
Wood Bats, Maple Bats, Ash Bats - D-Bat, Inc. Wood Bats, Maple Bats, Ash Bats - D-Bat, Inc, Order Baseball Bats Online. Check us out on:. Become a fan of DBat on Facebook. Follow DBat on Twitter. Subscribe to DBat's YouTube channel. Pro D-Lite Ash Baseball Bats. Pro Stock Ash Baseball Bats. Pro Cut Ash Baseball Bats. Closeout Ash Basbeall Bats. Pro Player Ash Baseball Bats. Pro Maple Baseball Bats. Custom PRO Maple Baseball Bats. Pro Select Series - Baseball Gloves. Select Series - Fielding Gloves.
DBA advice | Oracle mastermind at work!
Oracle mastermind at work! Oracle 10g Five Important INIT.ora Parameters. March 16, 2007 in oracle. Using Oracle’s Automatic Shared Memory Tuning, you can instruct Oracle to manage a subset of the components that make up the SGA by setting the target size of the SGA through the new SGA TARGET parameter. Oracle will pool from this value and dynamically distribute memory across selected components of the SGA. Dynamic Sampling was first introduced in Oracle 9i. Its purpose is to help the Cost Based Opti...
Oracle DBA Tips
Monday, August 9, 2010. Tip#28 Thin (JDBC) Vs Thick (OCI) Driver. JDBC Thin Vs OCI (Thick). Loads of info available on what it means and which one to use etc etc. I just put two of the links which says it all,. Generally the Thin driver is the best choice. In most cases it is as fast or faster than the OCI driver (from 10.1.0), has almost exactly the same set of features, and is easier to administer. The Thin driver is easier to administer since it does not require installation of the OCI C libraries.
IT Management Tipster
Monday, May 9, 2011. What is SQL Server? Have you ever wonder what exactly is SQL Server? If so, check out this blog that explains SQL Server and it's services in great detail. What is SQL Server? Monday, April 18, 2011. Did you realize that transaction logs can be fragmented? Well, not only can your transaction logs be fragmented but fragmentation can affect your transaction log’s performance and also delay database recovery. Occurs when logs are not pre-sized and grows ( auto grow. Database snapshot ar...
www.dbatisociety.com
Welcome To Dr. Bhimrao Ambedkar Training Institut. Certificate in web designing. Diploma in web designing. Diploma in Information Technology. Diploma in Advance Software Development. Diploma In Graphic Designing. Diploma In Computer Hardware. Diploma In Computer Hardware and Networking. Basic English Speaking Course. Diploma In Fashion Designing. Diploma In Beauty Culture.
Dbatista's blog - Blog de Dbatista - Skyrock.com
09/01/2009 at 11:09 AM. 25/04/2009 at 5:30 AM. Subscribe to my blog! Toute l équipe des gentil a peu près. Don't forget that insults, racism, etc. are forbidden by Skyrock's 'General Terms of Use' and that you can be identified by your IP address (66.160.134.3) if someone makes a complaint. Please enter the sequence of characters in the field below. Posted on Friday, 17 April 2009 at 12:15 PM. Please enter the sequence of characters in the field below. Posted on Monday, 09 March 2009 at 12:39 PM. Please ...
DBatista Photography Wedding Photographers in Orlando FLorida
