Tag Archives: db

SQL Statement to get version of your Oracle DB

> sqlplus / as sysdba SQL> select * from v$version; BANNER ——————————————————————————– Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production PL/SQL Release 11.2.0.2.0 – Production CORE 11.2.0.2.0 Production TNS for Linux: Version 11.2.0.2.0 – Production NLSRTL Version 11.2.0.2.0 … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

Get List of ASM Disks in an 11gR2 Database

select * from v$asm_disk

Posted in Oracle | Tagged , , , | Leave a comment

How to compile all Oracle DB 11gR2 Invalid Objects

Login to SQLPlus Run the following statement: “@?/rdbms/admin/utlrp.sql”

Posted in Oracle | Tagged , , , , , , | Leave a comment

How to query Oracle DB 11g for user account status

select USERNAME,ACCOUNT_STATUS from dba_users where USERNAME=’PUT_YOUR_USER_NAME_HERE’; Sample output: USERNAME                                    ACCOUNT_STATUS ——————————           ——————————– SADMIN           … Continue reading

Posted in Oracle | Tagged , , , | Leave a comment

How to run the Oracle Data Pump Command as sysdba

If you have access to the Oracle DB server OS and user (e.g. via ssh or telnet), then you don’t need to have credentials for any DB user to be able to run the data pump commands, all you have … Continue reading

Posted in Oracle | Tagged , , , , , | Leave a comment