Handy Oracle SQL commands

Sunday, May 20, 201219comments

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 + 19 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/

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