Handy Oracle SQL commands

Sunday, May 20, 201238comments

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 + 38 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

May 4, 2016 at 11:29 PM

Thanks for the great information ,was looking for this information from long.Great blog SAP Basis Training in Chennai

August 22, 2016 at 11:50 PM

Great place to learn new things and got the best SAP BASIS Training in Chennai

December 24, 2016 at 2:19 AM

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

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

March 7, 2017 at 1:25 AM

Blogs are so informative where we get lots of information on any topic. Nice job keep it up!! industrial training jalandhar

March 13, 2017 at 11:49 PM

wow really superb you had posted one nice information through this. Definitely it will be useful for many people. So please keep update like this.

MSBI Training in Chennai

Informatica Training in Chennai

April 12, 2017 at 5:50 AM


That is very interesting; you are a very skilled blogger. I have shared your website in my social networks..!

Payday loans in Alabama
Title loans in South Carolina

June 7, 2017 at 5:06 AM



Wonderful blog.. Thanks for sharing informative Post. Its very useful to me.

Installment loans
Payday loans
Title loans

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/

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

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:09 AM

Its fantatic explaintion lot of information gather it...nice article....
seo company in Chennai

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

July 11, 2017 at 11:49 PM

SAP BASIS Training in Chennai is provided by

THE CREATING EXPERTS they provide hands on training with real time scenarios

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

contact 8122241286 for more info

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

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 1:39 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

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

July 24, 2017 at 2:26 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

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.

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

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.

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.

August 3, 2017 at 7:41 AM


Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much

Personal Installment Loans
Payday Cash Advance loan
Title Car loan
Cash Advance Loan

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 6, 2017 at 10:25 PM

This information is impressive; I am inspired with your post writing style & how continuously you describe this topic.

Eczema Treatment
Psoriasis Oil
Hyperpigmentation Treatment
Herbal Tonic

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...

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