Handy Oracle SQL commands

Sunday, May 20, 201242comments

Here i am listing some Oracle Sql commands which are very useful useful many times.

1.Count no. of records in a table
     select count(*) from sapsr3.vbfs;

2. Count no. of sessions in db
SELECT inst_id, count(*) "DB Sessions" FROM gv$session  WHERE type = 'USER' GROUP BY inst_id;

3.Check status of file in recovery
  select FILE#,STATUS from v$datafile where status like '%REC%';

4. Check status of file in Offilne state
  select FILE#,STATUS from v$datafile where STATUS like 'OFFLINE';

5. Rebuild index online
  alter index "SAPSR3"."RSSTATMANREQMAP~PT" rebuild online;

6.Check last optimizer statiscs run
  select TABLE_NAME, STATUS, LAST_ANALYZED from DBA_TABLES where TABLE_NAME='VBFS';

7. Determine file name from file id.
  select FILE_NAME from dba_data_files where FILE_ID in (56,59,60,61,62,63,65,66,67,68);




Share this article :

+ comments + 42 comments

September 26, 2014 at 9:08 PM

good information provide.
http://quizexpo.com http://naukriexpo.com

October 29, 2014 at 9:02 AM

Thanks for Information SAP FICO Online Training

January 22, 2015 at 3:23 AM

Very useful information thanks for sharing information.. SAP Basis Support Services

August 17, 2015 at 7:02 AM

I appreciate you sharing this article. Really thank you! Much obliged.
This is one awesome blog article. Much thanks again.


sap online training
software online training
sap sd online training
hadoop online training
sap-crm-online-training

August 17, 2015 at 7:03 AM

This is one awesome blog article. Much thanks again.
I really enjoy the blog.Much thanks again. Really Great.


sap online training
software online training
sap sd online training
hadoop online training
sap-crm-online-training

December 27, 2015 at 10:18 PM

Very useful really good information thanks for posting such a good information it will hepls the people a lot keep it up , Regards
Learn SAP Online | SAP Help Portal

January 14, 2017 at 7:05 AM

Thanks for sharing great information in your blog. Got to learn new things from your Blog . It was very nice blog to learn about SAP BASIS.
Call us at 8122241286.
SAP basis

January 17, 2017 at 9:39 PM

Creating experts, A leading career development organization provides Real time training in SAP Success Factors, SAP MM, SAP SD, SAP ABAP, SAP BASIS,SAP BASIS, SAP FICO, with live examples by corporate Experts.
www.thecreatingexperts.com (Best SAP training institute in chennai with placement assistance)
SAP Success Factor, SAP MM Training in chennai Vadapalani ECR velachery Tambaram
SAP basis training in chennaai

January 20, 2017 at 9:47 PM

Ad 7 SAP BASIS
It was very nice blog to learn about SAP BASIS. Thanks for sharing
We provides Best SAP BASIS. Training in Chennai with real time project assistance by our leading SAP BASIS. Consultant.
For Free Live Demo @ Call to 8122241286.
SAP MM, SAP SD, SAP HR,SAP FICO 
www.thecreatingexperts.com 
.SAP basis

March 3, 2017 at 3:23 AM

Webtrackker technology is the best IT training institute in NCR. Webtrackker provide training on all latest technology such as Sap Basis training. Webtrackker is not only training institute but also it also provide best IT solution to his client. Webtrackker provide training by experienced and working in the industry on same technology.Webtrackker Technology C-67 Sector-63 Noida 8802820025

SAP basis Training institute in indirapuram


SAP basis Training institute in Noida


SAP basis Training institute in Ghaziabad


SAP basis Training institute in Vasundhara


SAP basis Training institute in Vaishali


SAP basis Training institute in Delhi South Ex

Anonymous
June 16, 2017 at 11:23 PM

Thank you for your post..much helpful to know things better.

I personally got trained with THE CREATING EXPERTS one of the best trainer in CHENNAI with hands on training in real time scenarios.

It would be useful for the viewers to take a look at the provided link below for SAP trainings.

http://thecreatingexperts.com/sap-basis-training-in-chennai/

Anonymous
June 29, 2017 at 6:23 AM

The Creating Experts is the leading trainer in SAP BASIS so, if you are looking for one here is the link

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact +91-08122241286

Anonymous
July 2, 2017 at 10:32 PM

SAP BASIS training is provided in CHENNAI.

THE CREATING EXPERTS is one of the leading trainer in SAP who provides real time training

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

July 11, 2017 at 3:45 AM

The Creating Experts provides training in SAP basis

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact +91-08122241286

Anonymous
July 14, 2017 at 5:46 AM

Nice blog....For a long time I was looking for SAP BASIS training in Chennai and got the link


THE CREATING EXPERTS is providing SAP BASIS training in real time

http://thecreatingexperts.com/sap-basis-training-in-chennai/

Contact 8122241286

Anonymous
July 15, 2017 at 3:57 AM

SAP BASIS training is provided in CHENNAI.I personally got trained with them one of the best trainers in CHENNAI

THE CREATING EXPERTS is one of the leading trainer in SAP who provides real time training

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

July 21, 2017 at 1:14 AM

Informative post...for a long time I was searching for a trainer in Chennai

And i landed with THE CREATING EXPERTS one of the leading trainer with real time training in Chennai

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info.

July 22, 2017 at 5:46 AM


SAP BASIS training is provided by THE CREATING EXPERTS

If you are looking for a real time trainer then take a look at the mail below

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286

Anonymous
July 27, 2017 at 7:17 AM

SAP basis training by THE CREATING EXPERTS

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contcat 8122241286 for more info.

If you are looking for SAP basis here is a real time trainer to get trained from.

Anonymous
July 28, 2017 at 8:47 AM

Creating experts, A leading career development organization with live examples by corporate Experts.

SAP training by online and classroom training is provided

http://thecreatingexperts.com/sap-basis-training-in-chennai/


Contact 8122241286 SAP basis training in chennai

Anonymous
July 30, 2017 at 1:57 AM

The Information you provided is very much useful for SAP Learners. This Information was very Interesting,

SAP training in Chennai by THE CREATING EXPERTS for SAP BASIS, take a look at the link below

http://thecreatingexperts.com/sap-basis-training-in-chennai/

contact 8122241286 for more info.

Anonymous
July 31, 2017 at 9:39 AM

NICE BLOG...SAP basis training in CHENNAI provided by THE CREATING EXPERTS

http://thecreatingexperts.com/sap-basis-training-in-chennai/

CONTACT 8122241286.

September 27, 2017 at 10:26 PM

Great post! I am actually getting ready to across this information, It's very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
SAP HR Training in Chennai
SAP ABAP Training in Chennai
SAP FICO Training in Chennai

November 8, 2017 at 9:05 PM

Thank you for Sharing Very USeful Commands On Oracle SQL. You Can Learn more about Oracle like Oracle atg, Oracle hrms etc...

March 16, 2018 at 12:41 AM

regarding this topic in an effective way.Thank you so much.
SAP BASIS training in Gurgaon

Anonymous
April 25, 2018 at 3:32 AM

Nice blog....For a long time I was looking for SAP BASIS training in and got the link Weblogic Application Server training

May 25, 2018 at 9:37 PM

Very Helpful Post And Explained Very Clearly About All the things.Very Helpful. Coming To Our Self We Provide Restaurant Equipment Parts Through Out US At Very Affordable Prices And Also We Offer Same Day Shipping In US.We Offer Only Genuine Products.Really Than ks for Sharing.

May 26, 2018 at 2:32 AM

This Blog is very helpful and useful,came to know that i should be strong in my basics and this blog helps me to improve it,Urgent Care Services Provided by Us.Thanks For Posting.I Am refereed by my friend
to this blog and a=i also want to refer my other friends to this blog.

July 9, 2018 at 2:19 AM

Really Thanks For Posting Such a Useful and informative article. I would like to share this blog with my friends and Colleagues Tico Certification Training

August 24, 2018 at 11:18 PM

Your post is really very helpful. Easy to learn as you explain things precisely. Thank you
erp software in chennai

Education erp software in chennai

October 5, 2018 at 1:46 AM

http://ibdpartnership.blogspot.com/SQream Technologies provides you with a state of the art software which combines modern GPU technology (Graphic Processing Units) with the best practices in today’s Big Data platforms, providing up to 100x faster insights from data.
Bigdata Training in Chennai OMR

October 1, 2020 at 3:26 AM

I appreciate this piece of useful information. Kshemkari Export Import academy one of the best
leading Trade and Training Institute for import and export business, provides the best service in India with expert Team For more information visit our site: Import Export Online Training

November 10, 2022 at 10:41 PM

Download Edius Pro 9.10.3086 + Crack + Trial Reset Free Full Download. · Edius 9 Crack New Features: – H.265 (HEVC) export using Intel Quick Sync Video.Edius X Crack

Post a Comment
 
Support : Basis SAP | Basis SAP | Basis SAP
Copyright © 2011. Basis SAP - All Rights Reserved
Template Created by Basis SAP Published by Basis SAP
Proudly powered by Blogger