dbaregistry.blogspot.com
OracleOracle DBA FAQ,Oracle Interview Questions, Oracle 11g new featurs
http://dbaregistry.blogspot.com/
Oracle DBA FAQ,Oracle Interview Questions, Oracle 11g new featurs
http://dbaregistry.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
1.7 seconds
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
63
SITE IP
172.217.6.65
LOAD TIME
1.703 sec
SCORE
6.2
Oracle | dbaregistry.blogspot.com Reviews
https://dbaregistry.blogspot.com
Oracle DBA FAQ,Oracle Interview Questions, Oracle 11g new featurs
dbaregistry.blogspot.com
Oracle: Oracle Database 11g: New Features in datapump
http://dbaregistry.blogspot.com/2010/01/oracle-database-11g-new-features-in_6425.html
Oracle Database for DBA and Developers. Oracle Database 11g: New Features in datapump. COMPRESSION parameter in expdp. One of the big issues with Data Pump was that the dumpfile couldn't be compressed while getting created. In Oracle Database 11g, Data Pump can compress the dumpfiles while creating them by using parameter COMPRESSION in the expdp command line. The parameter has three options:. METDATA ONLY - only the metadata is compressed. ALL - both the metadata and data are compressed. Labels: 11g: Ne...
Oracle: Welcome to Oracle DBA Forum Home
http://dbaregistry.blogspot.com/2010/02/welcome-to-oracle-dba-forum-home.html
Oracle Database for DBA and Developers. Welcome to Oracle DBA Forum Home. Server Administration, Performance Tuning. Latches and Latch Contention. How To find The Row Which is Locked by a Session. SQL : Useful scripts for DBA. Oracle Real Application Clusters (RAC). Oracle RAC Interview questions. RAC Load Balancing, TAF , FAN. When during the installation process are clusterware components created. Steps to move OCR and Voting disk. Steps to Restore RAC Database to Single Instance. Labels: * Home *.
Oracle: RMAN DUPLICATE WITHOUT CONNECTING TO TARGET DATABASE IN 11GR2
http://dbaregistry.blogspot.com/2011/04/rman-duplicate-without-connecting-to.html
Oracle Database for DBA and Developers. RMAN DUPLICATE WITHOUT CONNECTING TO TARGET DATABASE IN 11GR2. Prior versions of Oracle required a connection to the TARGET and optional rman catalog for duplicate database. In 11GR2, we can perform RMAN duplicate database to a new server without connecting to the target database or a recovery catalog. 1) Take backup of the database. RMAN Configure controlfile autobackup on;. RMAN backup database plus archivelog;. 3) Create an init.ora for duplicate database. RMAN-...
Oracle: How to export and import crs resources while migrating Oracle RAC to new server.
http://dbaregistry.blogspot.com/2011/07/how-to-export-and-import-crs-resources.html
Oracle Database for DBA and Developers. How to export and import crs resources while migrating Oracle RAC to new server. Below script generate svrctl add script for database, instance, service and 11G listeners from OCR from current RAC. Save the result of the script and run it at new RAC. For DBNAME in $(srvctl config database). Srvctl config database -d $DBNAME -a awk -v dbname="$DBNAME". BEGIN { FS=":" }. 1 /Oracle home/ $1 /ORACLE HOME/ {dbhome = "-o" $2}. 1 /Spfile/ $1 /SPFILE/ {spfile = "-p" $2}.
Oracle: Oracle Wait Events
http://dbaregistry.blogspot.com/2010/01/oracle-wait-events.html
Oracle Database for DBA and Developers. Before looking into wait events, let us understand various state of user process. Oracle user process is typically in one of the three states:. A Idle wait. e.g. 'SQL*Net message from client'. B Running code - Either on CPU or on a run queue. Oracle itself does not know if it is on-CPU or just on a run queue. I for some resource to become available. e.g. enqueue (lock) or a latch. Ii for an activity to complete that it has requested. Like an IO read request. WAITIN...
TOTAL PAGES IN THIS WEBSITE
19
Oracle DBA - Concepts and Techniques: Oracle 11g New Features
http://salaic-dbaoracle.blogspot.com/2011/02/oracle-11g-new-features.html
Oracle DBA - Concepts and Techniques. Oracle 11g New Features. 1 Make table ready only using alter command. 10g and earlier versions read only can be done by giving read access. In 11g this can be done using alter table command. SQL select table name, read only from user tables where table name = 'EMP';. SQL alter table emp read only;. SQL select table name, read only from user tables where table name = 'EMP';. SQL alter table emp read write;. Ex alter table emp storage (flash cache keep);. Unix Q and A.
Oracle DBA - Concepts and Techniques: Oracle Errors and Fixes
http://salaic-dbaoracle.blogspot.com/2007/11/oracle-errors-and-fixes.html
Oracle DBA - Concepts and Techniques. Oracle Errors and Fixes. 1 Error/Warning in alertlog:. If you set the Parameter 'log archive max processes' to 2, two archival processes will be started at database startup. One was shut down because it was not needed. This the reason for the error:. The message about 'db recovery file dest size' is not an error. This indicates how much space is used for flashback recovery since flash back is enabled for this instance. Related sql: select * from V$ARCHIVE PROCESSES;.
Oracle DBA - Concepts and Techniques: Oracle PL/SQL Q and A
http://salaic-dbaoracle.blogspot.com/2009/04/oracle-plsql-q.html
Oracle DBA - Concepts and Techniques. Oracle PL/SQL Q and A. Q1 Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger? ANS 1: Yes, it is possible ,provide the trigger is autonomus or else table mutation occurAutonomus trigger can be defined using the trigger beggining with Pragma autonomus trancation and the trigger must have a commit/rollback statment at the end of the trigger. Q2 What are REGEXP LIKE, REGEXP REPLACE, REGEXP SUBSTR? Select zip from zip tables.
PURSUE ORACLE: October 2009
http://pursueoracle.blogspot.com/2009_10_01_archive.html
Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Saturday, October 17, 2009. Import/ Export from multiple schema. Fromuser=(USER01, USER02, USER03, USER04). Touser=(USER01, USER02, USER03, USER04). Subset of a table import. Exp scott/tiger tables=emp query="where deptno=10". From sys.v $sqlarea. DO NOT e...
PURSUE ORACLE: November 2009
http://pursueoracle.blogspot.com/2009_11_01_archive.html
Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Monday, November 16, 2009. VARCHAR2( 10 ) and VARCHAR2( 10 CHAR). By default, when you declare a variable VARCHAR2( 10 ), Oracle allocates. 10 bytes of storage. If you use a variable-length character set (i.e. Subscribe to: Posts (Atom). Http:/ asktom....
PURSUE ORACLE: April 2009
http://pursueoracle.blogspot.com/2009_04_01_archive.html
Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Monday, April 6, 2009. UNISTR ASCIISTR SUBSTRB LENGTHB. Select nvarchar2 field FIELD , Lenght(nvarchar2 field) LENGTH, LenghtB(nvarchar2 field) LENGTB. LengthB gives the size in bytes,. Length gives the size in characters. More use of LENGTHB. The followin...
PURSUE ORACLE: RMAN Tutorial
http://pursueoracle.blogspot.com/2010/07/rman-tutorial.html
Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Monday, July 26, 2010. Ability to perform incremental backups.Ability to recover one block of a datafile. Ability to perform the backup and restore with parallelization. Ability to automatically delete archived redo logs after they are backed up. With the ...
PURSUE ORACLE: January 2010
http://pursueoracle.blogspot.com/2010_01_01_archive.html
Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Tuesday, January 12, 2010. Http:/ asktom.oracle.com/pls/asktom/f? P=100:11:818301469484507: : P11 QUESTION ID:146412348066. Dbms output.put line has limitation of 255 characters. Procedure p( p string in varchar2 ). L string long default p string;. Put( s ...
PURSUE ORACLE: Index, Bitmap Index, B-Tree, IOT
http://pursueoracle.blogspot.com/2010/07/index-bitmap-index-b-tree-iot.html
Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Sunday, July 25, 2010. Index, Bitmap Index, B-Tree, IOT. Index, Bitmap Index, B-Tree Index. Oracle's two major index types are Bitmap indexes and B-Tree indexes. Characteristic of Bitmap Indexes:. For columns with very few unique values (low cardinality).
PURSUE ORACLE: RMAN Enhancements in Oracle Database 10g
http://pursueoracle.blogspot.com/2010/07/rman-enhancements-in-oracle-database.html
Oracle Technologies not a dark-art; they work in an entirely predictable and even intuitive way. Understanding how the stuffs works moves applying taught from the realm of guesswork to that of science; so embrace the technology and read the manual…………. Monday, July 26, 2010. RMAN Enhancements in Oracle Database 10g. RMAN Enhancements in Oracle Database 10g. Http:/ www.oracle-base.com/articles/10g/RMANEnhancements10g.php. The flash recovery area. Multiplexed online redo logs. Using this feature all change...
TOTAL LINKS TO THIS WEBSITE
63
DBA References
Greenplum DBA LinkedIn Group. Oracle DBA Quick References. Top 20 Unix Commands. Top 20 SQL Scripts. Top 20 Vi Commands. Top 20 v$ views. Shop Amazon Gold Box - New Deals. Everyday. Unix Scripts for Oracle DBA's. Oracle 11g New Features. SQL Scripts for Oracle DBA's. UNIX and Linux for Oracle DBA. Windows OS and Oracle DBA. DBA Tips and Tricks. Find command in Unix. Greenplum DBA - Understanding the Greenplum database architecture. Greenplum DBA - Steps to migrate data from Oracle to Greenplum. Posted Oc...
I Need an API Key | Just another WordPress.com weblog
I Need an API Key. Just another Wordpress.com weblog. May 12, 2006. Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging! Create a free website or blog at WordPress.com.
dbaregistration.com at Directnic
dbaregistration.net at Directnic
Oracle
Oracle Database for DBA and Developers. Welcome to Oracle DBA Forum Home. Server Administration, Performance Tuning. Latches and Latch Contention. How To find The Row Which is Locked by a Session. SQL : Useful scripts for DBA. Oracle Real Application Clusters (RAC). Oracle RAC Interview questions. RAC Load Balancing, TAF , FAN. When during the installation process are clusterware components created. Steps to move OCR and Voting disk. Steps to Restore RAC Database to Single Instance. Labels: * Home *.
Official DBA Registration.
Require once(/home/content/88/11990288/html/dba/wp-load.php) [ function.require-once. Failed to open stream: No such file or directory in /home/content/88/11990288/html/dba/wp-blog-header.php. Require once() [ function.require. Failed opening required '/home/content/88/11990288/html/dba/wp-load.php' (include path='.:/usr/local/php5 3/lib/php') in /home/content/88/11990288/html/dba/wp-blog-header.php.
Home
Mdash; The 5 Step Method. The 5 Step Method unique approach. Scope regulation in the life cycle in the telecom industry. Http:/ www.dbaregulation.com/modules/mod image show gk4/cache/blankgk-is-87.png link.
Holding page for www.dbarelectric.com hibu.com
Welcome to your future website! Your website is currently under construction, please check back later. Got a query or want some help? Give us a call, our team are happy to help. For US customers, call 1-800-YB-YELLOW. For UK customers, call 0800 555 444. For Spain customers, call 902 202 202. For Argentina customers, call 0810 333 8080. For Chile customers, call 600 262 7455. For Peru customers, call 0800 11122.
