oracledbaroutinetasks.blogspot.com
dbaSubscribe to: Posts (Atom). View my complete profile.
http://oracledbaroutinetasks.blogspot.com/
Subscribe to: Posts (Atom). View my complete profile.
http://oracledbaroutinetasks.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Friday
LOAD TIME
0.7 seconds
16x16
32x32
64x64
128x128
PAGES IN
THIS WEBSITE
0
SSL
EXTERNAL LINKS
12
SITE IP
74.125.22.132
LOAD TIME
0.69 sec
SCORE
6.2
dba | oracledbaroutinetasks.blogspot.com Reviews
https://oracledbaroutinetasks.blogspot.com
Subscribe to: Posts (Atom). View my complete profile.
Oracle DBA Scripts: BIND VARIABLE PEEKING
http://oracledbascripts.blogspot.com/2010/08/bind-variable-peeking.html
Oracle Production support DBA Tips. Want to post your scripts here in this blog? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts. Monday, August 23, 2010. There are 3 things that might put you at risk of unstable plans due to bind variable peeking. 1 Histograms: The histogram tells Oracle about data distribution. Select column name, endpoint number, endpoint value. From dba tab histograms. Where table name='TEST INVOICE';. Labels: BIND VARIABLE PEEKING.
Oracle DBA Scripts: January 2010
http://oracledbascripts.blogspot.com/2010_01_01_archive.html
Oracle Production support DBA Tips. Want to post your scripts here in this blog? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts. Wednesday, January 13, 2010. Oracle Critical File Protection. Step 1: Collect the file locations for control, redo log, and data files:. Step 2: Check file permission. Select 'Control Files: ' value from v$parameter where name= 'control files';. Select 'Control Files: ' value from v$parameter where name= 'spfile';. AND name not in.
Oracle DBA Scripts: August 2010
http://oracledbascripts.blogspot.com/2010_08_01_archive.html
Oracle Production support DBA Tips. Want to post your scripts here in this blog? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts. Friday, August 27, 2010. When we last gathered stats in Oracle 11G. Select * from dba optstat operations;. To see the current retention value,. Select dbms stats.get stats history retention from dual;. Monday, August 23, 2010. There are 3 things that might put you at risk of unstable plans due to bind variable peeking. 4 recreate ...
Oracle DBA Scripts: July 2010
http://oracledbascripts.blogspot.com/2010_07_01_archive.html
Oracle Production support DBA Tips. Want to post your scripts here in this blog? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts. Friday, July 16, 2010. Shrink table in Oracle 10g/11g. In oracle 9i and below you need to export the table, drop the table and import the table to reclaim the unused space. In oracle 10g you need to perform following sql commands to reclaim the table unused space. SQL alter table sachi enable row movement;. X := 'T';. X := 'F';.
Oracle DBA Scripts: May 2009
http://oracledbascripts.blogspot.com/2009_05_01_archive.html
Oracle Production support DBA Tips. Want to post your scripts here in this blog? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts. Wednesday, May 20, 2009. Find the tables/indexes that have stale statistics in a database. Using the code below one can find the tables/indexes that have stale statistics in a database, when options= ’GATHER AUTO’. Is used oracle gathers statistics analyzes the tables/indexes that have stale statistics. Table monitoring is. Column...
Oracle DBA Scripts: September 2009
http://oracledbascripts.blogspot.com/2009_09_01_archive.html
Oracle Production support DBA Tips. Want to post your scripts here in this blog? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts. Friday, September 18, 2009. How to find locked oracle database user account details. USER AUDIT SESSION contains audit trail records concerning connections and disconnections of the current user. Select os username, username,userhost,terminal,timestamp,action name,logoff time,RETURNCODE. DBA AUDIT SESSION table. LOGOFF LWRITE NUMB...
Oracle DBA Scripts: July 2007
http://oracledbascripts.blogspot.com/2007_07_01_archive.html
Oracle Production support DBA Tips. Want to post your scripts here in this blog? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts. Tuesday, July 31, 2007. Complete guide to becoming an Oracle database administrator. Complete guide to becoming an Oracle database administrator. Labels: Complete guide to becoming an Oracle database administrator. Thursday, July 12, 2007. Oracle 11g new Features. Real Application Testing Helps Reduce Time, Risk and Cost of Change.
Oracle DBA Scripts: shrink the undo tablespace to free up some disk space after some unusual database activity
http://oracledbascripts.blogspot.com/2010/08/shrink-undo-tablespace-to-free-up-some.html
Oracle Production support DBA Tips. Want to post your scripts here in this blog? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts. Friday, August 20, 2010. Shrink the undo tablespace to free up some disk space after some unusual database activity. 1 define a new temporary undo tablespace. CREATE UNDO TABLESPACE "UNDOTBS2" DATAFILE '/u01/oradata/xxxx/undotbs201.dbf' SIZE 100M. AUTOEXTEND ON NEXT 10240K MAXSIZE 32767M ;. Labels: Shrink undo tablespace in 10g.
Oracle DBA Scripts: August 2007
http://oracledbascripts.blogspot.com/2007_08_01_archive.html
Oracle Production support DBA Tips. Want to post your scripts here in this blog? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts. Thursday, August 16, 2007. Difference between the PFILE, SPFILE and INIT.ORA. Difference between the PFILE, SPFILE and INIT.ORA, and what is the function of each? STARTUP PFILE=/home/oracle/7.3/dbs/init weekend.ora. Initialization Parameter Files and Server Parameter Files. Labels: Difference between the PFILE.
TOTAL LINKS TO THIS WEBSITE
12
Under Construction
Oracle DBA Junior
Thứ Tư, 26 tháng 9, 2012. Không có nhận xét nào:. Thứ Năm, 2 tháng 6, 2011. Identify object with troubleshooting SQL. Tanel (http:/ blog.tanelpoder.com/) is the famous DBA over the world who help many Database Administrators. I like him very much, I often download his videos, articles and read or watch them many many time. One of the best article is Snapper Session, in which, he introduced many thing about session activity, how will you do tracing, tracking and identifying top sql. I attached my script:.
Oracle DBA Online Training | Oracle DBA Online Training
Learning is not attained by chance, it must be sought for with ardor and diligence.". Tell me and I forget. Teach me and I remember. Involve me and I learn.". We offers the industry’s best Oracle DBA Training. We are a group of working professionals from fortune 500 organizations. We deliver Oracle DBA Online Training all over the world with distinctive training methods.Our key motto is to help the Learners globally for a very low affordable and reasonable price on Oracle DBA Online Training. We also gui...
oracledbaonlinetrainingblog.wordpress.com
oracledbaonlinetrainingblog
This is the post excerpt. This is your very first post. Click the Edit link to modify or delete it, or start a new post. If you like, use this post to tell readers why you started this blog and what you plan to do with it. May 26, 2016. Leave a comment on First blog post. Oracle DBA Online Training in France. A database administrator’s responsibilities will embody the following tasks:. Installing and upgrading the Oracle server and the application tools. Controlling and monitoring user access to the info.
oracledbaonlinetrainingtutorials.wordpress.com
oracledbaonlinetrainingtutorials
Oracle DBA Training classes Tutorial certification in Ameerpet Hyderabad. June 22, 2015. By Miracle soft solutions. Learn and get trained Oracle DBA Online training. In 11g data base in corporate environment offering Oracle apps ,admin and RAC training courses with certified instructor. Miracle soft solutions offer a High range of Quality and dedicated Training with Real time Industry expert in respective specialization throughout the Globe in corporate environment. Duration of the Course: 30 -35 hrs.
Oracle Apps DBA
Tuesday, December 22, 2009. Move Grid Control Agent Repository To Another Server. Change Grid Control Agent Repository To Another Server. 1 Stop the agent. AGENT HOME/bin: emctl stop agent. Oracle@test ]$ $AGENT HOME/bin/emctl stop agent. Oracle Enterprise Manager 10g Release 10.2.0.1.0. Stopping agent . stopped. 2 Edit the AGENT HOME/sysman/config/emd.properties file. Change the following lines to port 4889. Make sure to back up this file before editing:. 3 Delete these files from the agent home. Check ...
-- Welcome to oracle DBAS --
On Call 24x7 Services. Welcome to www.oracledbas.com. Oracle DBAs provide end-to-end Oracle Database and Applications professional services by delivering maximum ROI - the people, expertise and processes - from one single source. Bringing all the benefits of Oracle DBAs All-in-One at a fixed price and fixed scope or at a variable price model, It provides a lower total cost of ownership, and a predictable investment in a long-term. Oracle is a registered trademark of Oracle Corporation.
Web hosting, domain name registration and web services by 1&1 Internet
THIS DOMAIN NAME HAS JUST BEEN REGISTERED FOR ONE OF OUR CUSTOMERS! Do you need affordable web hosting or a domain name? 1&1 Internet is trusted by millions. Find out why. Offers a one-stop shop for all your domain name and web hosting needs so you can maximize your full web potential — without barriers, and without fear. Smart webmasters choose 1&1 Internet for domain name registration and hosting solutions. All-Inclusive Hosting Plans with NO Hidden Charges. 24/7 Phone and E-mail Support.
Web hosting, domain name registration and web services by 1&1 Internet
THIS DOMAIN NAME HAS JUST BEEN REGISTERED FOR ONE OF OUR CUSTOMERS! Do you need affordable web hosting or a domain name? 1&1 Internet is trusted by millions. Find out why. Offers a one-stop shop for all your domain name and web hosting needs so you can maximize your full web potential — without barriers, and without fear. Smart webmasters choose 1&1 Internet for domain name registration and hosting solutions. All-Inclusive Hosting Plans with NO Hidden Charges. 24/7 Phone and E-mail Support.
ORACLE DATABASE
An ERROR FREE and EASY TO UNDERSTAND description of various operations of oracle database. All description about various things have been tested and then presented to you. No great genius has ever existed without some touch of madness. View my complete profile. Monday, 23 March 2015. Oracle Multimedia , JAVAM and XML components , ora-04031. To install Oracle Multimedia, first you need to check for the existence of JAVAM and XML components into database. Doc ID 337415.1)". Start of File full rmjvm.sql.
