Database Commands

Database Useful Commands
---------------------------
Listner Commands
-------------------
lsnrctl start
lsnrctl stop
lsnrctl status
lsnrctl service
Tnsping
-------------------
ping localhost
tnsping localhost
tnsping orcl
Tablespaces
---------------
select * from USER_TABLESPACES;
select * from V$TEMPFILE;
SELECT * FROM DBA_DATA_FILES;
SELECT * FROM v$datafile;
SELECT * FROM v$log;--REDO LOGS
SELECT * FROM v$archived_log;--ARCHIVE LOGS

 How to determine the database character set in oracle?
----------------------------------------------------------
select * from NLS_DATABASE_PARAMETERS
    where parameter='NLS_CHARACTERSET'; --AL32UTF8
   
SELECT value$ FROM sys.props$ WHERE name='NLS_CHARACTERSET';  --AL32UTF8 

select distinct(nls_charset_name(charsetid)) CHARACTERSET,
decode(type#, 1, decode(charsetform, 1, 'VARCHAR2', 2, 'NVARCHAR2','UNKNOWN'),
9, decode(charsetform, 1, 'VARCHAR', 2, 'NCHAR VARYING', 'UNKNOWN'),
96, decode(charsetform, 1, 'CHAR', 2, 'NCHAR', 'UNKNOWN'),
8, decode(charsetform, 1, 'LONG', 'UNKNOWN'),
112, decode(charsetform, 1, 'CLOB', 2, 'NCLOB', 'UNKNOWN')) TYPES_USED_IN
from sys.col$ where charsetform in (1,2) and type# in (1, 8, 9, 96, 112)
order by CHARACTERSET, TYPES_USED_IN;
Explian Plan
--------------
explain plan for select Statements;
select PLAN_TABLE_OUTPUT
    from table(dbms_xplan.display('plan_table',null,'basic'));

select * from V$SQL;
select * from V$SQL_PLAN;
select * from V$SQL_PLAN_STATISTICS_ALL;

Govt. Sites

web sites of andhrapradesh government
Andhra Pradesh Government :- www.andhrapradesh.com
AndhraPradesh Portal :- www.aponline.gov.in
A.P.Dept. of Womens Dev.& Child Welfare :- www.apanganwadi.com
A.P.Commercial Tax :- www.apvatvision.com/Andhra
A.P.B.C.Co-op.Finance Corporation :- www.backwardclasscorporation.org
Anti-Corruption Bureau :- www.acbap.org
A.P.Dev.Co-op. Federation :- www.apdairy.com
A.P.Elect. Regulatory Authority :- www.ercap.org
A.P.Forests Dev. Corporation :- http://apfdc.apts.gov.in
A.P.Genco :- www.apgenco.com
A.P.Transco :- www.aptranscorp.com
A.P. Govt. Orders :- www.apts.gov.in
A.P. Housing Board :- http://aphb.apts.gov.in
A.P. Indus. Dev.Corp. :- www.apind.com
A.P. I.T.C.O. :- www.apitco.org
A.P.Mines & Geology :- www.minces.com
A.P.Police :- www.apstatepolice.org
A.P.Pollution Control Board :- www.apspcb.org
A.P.Press Academy :- www.apts.gov.in
A.P.Public Ditribution System :- www.nic.in/appds
A.P.Public Service Commission :- www.appsc.org
A.P.S.C.Of Higher Education :- www.apsche.com
A.P.S.Co-op. Marketing Federation :- www.apscmf.gov.in
A.P.State Financial Corporation :- www.apsic.com
A.P.State Housing Corporation :- www.apshcil.com
A.P. State Minority Financial Corporation :- www.apsmic.com
A.P.State Trading Corporation :- www.apstc.com
A.P.Tranport Corp. :- www.andhrapradesh.com
A.P.Tech. Dev.Promotion Centre :- www.aptdc.com
A.P. Technology Services Ltd. :- www.apts.gov.in
A.P.Telephones :- www.aptelcom.gov.in
A.P.Tourism :- www.aptourism.com
A.P.Infrastucture :- www.aponline.gov.in
A.P.Vidya Vidhana Parishad :- www.aphealth.org
Board Of Intermediate Education :- www.interboardap.nic.in
CARD- Dept. of Registration & Stamp :- www.ap.gov.in/card
Civil Suplies Corporation :- www.apts.gov.in/ramwec
Chief Minister's Empowerment of Youth :- www.cmey.com
Commisionerate of Industries :- www.apind.com
Commisionerate of Family Welfare :- www.apsect.gov.in
Commisionerate of Fisheries :- www.apfishries.com
Directorate of AIDS Control Project :- www.unaids.org
Directorate of Horticulture :- www.aphorticulture.com
Directorate of School Education :- www.schoolsinap.com
Directorate of State Institute of Edu.Tech :- www.siethyd.nic.in
Directorate of Tribal Cultural Research
& Training Institute :- www.apts.gov.in/aptribes
Directorate of Women Dev. &Child Welfare :- www.ap.nic.in
Direct Primary Education Programme :- www.apdped2000.com
Dr.B.R.Ambedkar Open University :- www.rbraou.com
Dr.MCR HRD Institute Of AP :- www.hrdap.gov.in
DWACRA :- www.ap.nic.in
Envir Protection,Training & Research :- www.eptri.com
Forest Department :- www.ap.nic.in
Girijan Co-op Corporation Lts :- www.apts.gov.in/aptribes
Hyderbad Muncipal Coporation :- www.ourmch.com
Guntur Muncipal Coporation :- www.gunturmuncipality.com
Tirupathi Urban Dev.Authority :- www.tuda.org
Tirupathi Zoo :- www.tirupathi.zoo.org
Vijayawada Muncipal Coporation :- www.vijayawada.com
Visakapatnam Muncipal Coporation :- www.visakapatnammuncipalcoporation.com
Hi Tech City :- www.tinlocity.com
Software Tech. Park of India :- www.stph.net
Hyderbad Metro Water Supply &
Sewerage Board :- www.hyderabadwater.gov.in
Hyderbad Traffic Police :- www.hyderbadtrafficpolice.com
Hyderbad Urban Dev.Authority :- www.hudahyd.com
IAS Officers Address :- www.apts.gov.in/address
Information Tech. & Commuin. Dept :- www.ap-it.com
Irrigaton Department :- www.apgov.in/apirrigation
JNTU :- www.jntu.ac.in
University of Hyderabad :- www.uohyd.emet.in
Panchayath Raj Engineering :- www.ap.in.in/nws
Roads & Buildings Department :- www.aproads.com
Transport Department :- www.tats.gov.in/transport
Small Savings :- www.apts.gov.in/apsmallsavings
Social Welfare Department :- http://swd.apts.gov.in
Social Welfare Residential Schools :- www.apts.gov.in/apswrs
State Board of Technical Edu.& Training :- www.sbtet.ap.nic.in
Velugu :- www.velugu.org
Corporation.com :- www.sowkarmyuam.com