Pavan DBA's Blog

The DBA Knowledge Store

Archive for the ‘General’ Category

Golden chance to listen to Oracle Experts in Dubai and UAE

Posted by Pavan DBA on May 21, 2014


Friends, a golden chance to people to listen to so many interesting sessions from Oracle Industry Experts like Oracle ACE, ACE Directors etc. It’s a Great opportunity to meet the Oracle experts, Meet Top Executives, Network with Other Senior DBAs, Database Managers in Dubai..

Event organized across UAE. You can attend physically or virtually by registering at http://otnmenatour.org/

For Dubai location see here – http://www.araboug.org/ib/index.php?app=nexus&module=payments&section=store&do=item&id=24

MENA OTN

Posted in General | Leave a Comment »

Wishing all my blog friends a very HAPPY NEW YEAR 2014

Posted by Pavan DBA on January 1, 2014


happy-new-year-2014-wallpaper-06

Posted in General | 3 Comments »

Finding the location of a row in the database

Posted by Pavan DBA on March 27, 2012


Friends, nice to write an article after really long time….

Earlier I posted an article on how to “How to identify in which datafile (of same tablespace) object is existing”. see that article here  – https://pavandba.com/2010/04/23/in-which-datafile-object-resides/

But in this article we will learn on how to check in which datafile (irrespective of any tablespace in the database) a row is existing i.e we are finding the location of a row in the database.

This is possible through DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO package and ROWID of a row. We all already know that ROWID is a unique identifier assigned by oracle to each and every row in the database and it is a hidden column in a table i.e every table will have a psuedo column called ROWID, but it will not be shown when we describe a table.

Let’s take a quick example

SQL> conn scott/tiger
Connected.

SQL> select rowid, DEPTNO, DNAME, LOC from dept;
 
ROWID                  DEPTNO DNAME          LOC
—————— ———- ————– ————-
AAAR3qAAEAAAACHAAA         10 ACCOUNTING     NEW YORK
AAAR3qAAEAAAACHAAB         20 RESEARCH       DALLAS
AAAR3qAAEAAAACHAAC         30 SALES          CHICAGO
AAAR3qAAEAAAACHAAD         40 OPERATIONS     BOSTON
 
SQL>
SQL> SELECT dbms_rowid.rowid_to_absolute_fno(‘AAAR3qAAEAAAACHAAD’, ‘SCOTT’, ‘DEPT’) FILEID FROM DUAL;
 
    FILEID
———-
         4

SQL> disc
SQL>
SQL> conn / as sysdba

SQL> SELECT TABLESPACE_NAME, FILE_NAME FROM DBA_DATA_FILES WHERE FILE_ID=4;

TABLESPACE_NAME
——————————
FILE_NAME
——————————————————————————–
USERS
/U01/ORA10G/PROD/USERS01.DBF

So, isn’t easy guys to find in which tablespace a row is existing 🙂

Hope this helps…. HAPPY LEARNING

Posted in General | Tagged: , , , | Leave a Comment »

Oracle webinar on cloud consolidation on 24th may 2011

Posted by Pavan DBA on May 10, 2011


 
Reduce your costs and increase responsiveness through Oracle Cloud Consolidation
Attend the Live Webcast on the 24th of May 2011 
 
Private cloud database consolidation can play a major role in helping your business reduce IT costs and complexity, while improving quality of service and agility. Join this Webcast and find out why database clouds offer more optimisation benefits than simple server consolidation.

In this Webcast you’ll learn:

• How consolidation onto private clouds can reduce your costs and increase responsiveness.
• The techniques businesses are using to successfully consolidate database environments.
• About customers who have consolidated hundreds of databases to a few private clouds and achieved better service at a lower cost.

Oracle consolidation can help you achieve maximum performance, data protection, and savings—up to a factor of 10 when it comes to storage costs – in the cloud.

Register now for this complimentary live Webcast.

For more information on Oracle webcasts please visit:
http://www.oracleapacwebcasts.com

If you are facing problems with registration, or would like further information, please email us at APACWebinars@OracleEvent.com

Date:
Tuesday
24th of May 2011
Time:
Mumbai 9:30 a.m.
(GMT +5.30)

Singapore 12:00 p.m.
(GMT +8.00)

Sydney 2:00 p.m.
(GMT +10.00)

Wellington 4:00 p.m.
(GMT +12.00)

The duration of this
Webcast is 45 minutes
For any questions on Oracle, our events and products please call or send us an email.
Australia 1300366386
New Zealand 0508 555 215
Brunei 800-065 then dial 6436 2417(*)
Indonesia 0800-1672-253 (int TF)
Malaysia 1800-801-837
Pakistan 00-800-11065 then dial 6436 2421(*)
Philippines 811-5831
Singapore 1800-672-2531
Sri Lanka / Colombo Metropolitan Area 2430-0800 then dial 6436 2419(*)
Sri Lanka / Other Areas 11-2430-0800 then dial 643 62419(*) 
Thailand 001-800 -4410545 
Vietnam 844-3944-7521
Hong Kong 800-901-039
Macau 0800-341
Taiwan 0800-672-253
India 0008001007789

Posted in General | Leave a Comment »

oppurtunity for oracle developers

Posted by Pavan DBA on April 13, 2011


Hi,

This email is from VertX Solutions.

VERTX Solutions is a professionally managed organization in servicing on Human Resource Service. Our expertise is in connecting the best professionals from different parts of the globe with the leading employers.
VertX was established in 2008 January, with registered office at Chennai, focused on Manpower service, Recruitment, Executive Search, specializing in Head-hunting and Systematic / Arduous Screening of professionals, to meet the increasing level of demands from the corporate world.

Currently, we have exciting a job opportunity with one of our client CMMI Level 5 Company.

The requirement is as follows

Looking for ORACLE DEVELOPERS with minimum 4 yrs to maximum 6 yrs of experience.

Should have experience in oracle Development .

Should have experience in design a Data mart.

Experience in performance tuning of oracle data mart.

Experience in design a code PL/SQL.

Experience in RUN SIT and UAT test cycles,investigating and resolve any issues that arise.

Shortlisted candidates have to attend the face to face interview on saturday (16.4.2011) in Hyderabad.

Job Location : Gurgaon
Experience : 4 – 6 Yrs.

If you are interested, kindly send your updated profile to praveenam@vertxsolutions.net ASAP with the following details.

Total Exp
Exp in Oracle development:
Exp in Data mart :
Current CTC :
Expected CTC :
Notice Period
Can able to join within one month : Yes/ No :

Kindly refer your friends who are looking for a change.

Ref1:
Ref 2:

Thanks & Regards
Praveena.M
Associate Consultant
VertX Solutions

Old No.12, New No.29,IInd Floor,9th Avenue
Ashok Nagar, Chennai – 600 082
Landline: 044 4502 2515
Mobile: 9500062415
E-Mail – praveenam@vertxsolutions.net
Visit us @ www.Vertxsolutions.net

Posted in General, Jobs | Leave a Comment »

 
%d bloggers like this: