Pavan DBA's Blog

The DBA Knowledge Store

Archive for the ‘General’ Category

« Previous Entries

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  – http://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 »

proactive Vs reactive tuning

Posted by Pavan DBA on August 23, 2010

Long back i posted a poll asking my friends, which type of tuning they will prefer…and to my expectation, almost 90% said Proactive tuning…

I doubt (or atleast not sure) if working DBA’s who polled for “proactive tuning” really follow the same in their work because Tuning is one area which DBA’s are afraid off (but ofcourse some people enjoy it :-) )

The answer for the poll is reactive tuning on major, but yes sometimes we do proactive tuning

Now, each kind of tuning is having its own advantages and disadvantages. In proactive tuning DBA need to concentrate or predict on future database problems which is very tough where as in reactive tuning, DBA should have good troubleshooting skills and should be a fast decision taker as sometimes PT problems dependent on client business.

So friends, conclusion is….DON’T TRY TO CHANGE WHICH IS ALREADY WORKING FINE by doing proactive tuning and DON’T BE SLOW when doing reactive tuning.

More articles are in pipeline on tuning methodologies….continue to watch this space….

Posted in General | Leave a Comment »

walkin in TCS, Hyd for various technologies

Posted by Pavan DBA on July 16, 2010

Java

Java J2EE (3-7 years of experience)
Struts JSP Servlets, Hibernate, Core Java

IBM Mainframe (MF)
Mainframe (3-7 years of experience)
Knowledge of IMS, JCL, COBOL, DB2

IT IS
Linux/ Solaris System Admim (Experience 4 years)
Solaris System administration and engineering experience with RedHat Linux ES 3, 4, and 5. Solaris 8 and Solaris 10
Working knowledge of complex web hosting configuration components, including firewalls, load balancers, web and database servers
Good understanding of Unix tools, DNS, Sendmail, and BIND fundamentals, including diagnostics
Well versed in Apache web server, PHP, MySQL and VMWare a plus.
The ability to deploy, support, and diagnose issues for a production environment running critical Oracle/SQL database applications

Service Capacity Analyst (Experience 4 years)
Unix(various utilization(CPU, memory) concepts), Oracle, Java – E1

Windows Admin (Experience 3-7 years)
IIS& Clustering & Load balancing Technologies
Windows Admin with IIS / Clustering / Load Balancing Technologies required

Windows Admin (Experience 3-7 years)
Directory skills , Server Admin
Windows Admin with strong AD skills required

Windows Admin (Experience 3-7 years)
IIS or SQL or SCOM
Windows Admin with SQL/IIS/SCOM

Windows Admin (Experience 3-7 years)
Server Admin – 2K, 2K3 & 2K8

Network Admin (Experience 3-6 years)
Switching & Routing
Network Admin with Lan / Wan /Firewall /Security

Unix Admin (Experience 3-6 years)
Solaris, HP Unix, Linux & AIX ( 3-6yrs)
Unix Admin with Solaris, HP Unix, Linux & AIX

Storage Admin & Architect (Experience 3-6 years)
EMC, Hitachi
Storage Admin with exp in EMC & Hitachi

Service Desk (Experience 3-5 years)
Service Desk for L1 Support
Good Accent neutralized candidate, Having troubleshooting skills in Desktop, Basic LAN issues, Outlook Mail client issues.

Application Packaging (Experience 3-5 years)
WISE Packaging Tool Experience
MS Technologies

Moss/ Sharepoint ( Experience 3-8 years)
Minimum of 3 yrs experience in .Net or Microsoft technologies of which at least 2 yrs of relevant experience in MOSS

SDET ( Experience 3-8 years)
Strong programming skill in C# .Good debugging AND testing knowledge,Ability to write automation system Ability to author test plan and cases, conduct security, stress test and debugging at source level after identify, investigating and priorities bugs

SAP SD
SAP SD Experience with at least 1 full SAP SD Project implementation of significant size, scope and complexity and 2 support project experience. Experience in O2C process and knowledge on interfacing modules like MM and FICO.

Siebel Config ( Experience 4-8 years)
Minimum of 4 yrs experience in Siebel Configuration with experience in implementation of Sales and Marketing Modules in Siebel
1. Full Time Graduates / Post Graduates in:
BE / BTech / ME / MTech / MSc / MCA / MCM / MS
CA / ICWA / MBA
PGDIT (2 years full time & approved by AICTE)
Special consideration will be given to B.Sc. / BCA / Diploma holders with 3 years of relevant functional / technical experience, subject to minimum reduction in experience, as per current TCS policy.
2. Consistent academic records from Class X onwards (Minimum 50%)
3. Candidates interviewed by us in the last 6 months are not eligible
4. Candidates with more than 2 years break in their academic / professional career will not be considered

A hardcopy of their CV
One passport size photograph
A photocopy of the last increment letter/offer letter, whichever is latest
The last drawn pay-slip

Venue:
Tata Consultancy Services Ltd.,
Kohinoor Park,
Plot No.1, Jubilee Gardens, Cyberabad,
Hyderabad 500 081

Registration Time: 09:30 AM to 12:30 PM
Date: 24th July, 2010 (Saturday)

i am not having referal name…anyone can provide it through comments

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

« Previous Entries
 
Follow

Get every new post delivered to your Inbox.

Join 1,477 other followers