Oracle Bits and Pieces
Posted: August 31, 2010 Filed under: IT Survival, Oracle, Oracle Admin Leave a comment »There a loads of little tips for adminastring Oracle, I am just starting out with a full system 10gR2 on Red Hat ES 4.
A very steep learning curve, got the SQL and PLSQL sorted its just the Oracle bit now. We have 3rd party DBA’s so it helps, some
of these tips are from me and some are from the professionals.
I will highlight any in RED if they have the potential to harm your system, please be careful though with any commands unless you are in your own test environment.
To see what databases are running
ps -ef | grep mon
To see what listners are active
ps -ef | grep lsnr
Installing Oracle on Linux CentOS
Posted: August 9, 2010 Filed under: IT Survival, Oracle, Oracle Admin Leave a comment »Link to really good guide
Oracle system tables
Posted: July 26, 2010 Filed under: IT Survival, Oracle, Oracle Admin Leave a comment »Below are some of the system table in Oracle (10gR2)
As I use the tables I will link useful and relevant SQL (Original)
| ALL_ARGUMENTS | Arguments in object accessible to the user |
| ALL_CATALOG | All tables, views, synonyms, sequences
accessible to the user |
| ALL_COL_COMMENTS | Comments on columns of accessible tables
and views |
| ALL_CONSTRAINTS | Constraint definitions on accessible tables |
| ALL_CONS_COLUMNS | Information about accessible columns in
constraint definitions |
| ALL_DB_LINKS | Database links accessible to the user |
| ALL_ERRORS | Current errors on stored objects that user
is allowed to create |
| ALL_INDEXES | Descriptions of indexes on tables accessible
to the user |
| ALL_IND_COLUMNS | COLUMNs comprising INDEXes on
accessible TABLES |
| ALL_LOBS | Description of LOBs contained in tables
accessible to the user |
| ALL_OBJECTS | Objects accessible to the user |
| ALL_OBJECT_TABLES | Description of all object tables accessible
to the user |
| ALL_SEQUENCES | Description of SEQUENCEs accessible to
the user |
| ALL_SNAPSHOTS | Snapshots the user can access |
| ALL_SOURCE | Current source on stored objects that
user is allowed to create |
| ALL_SYNONYMS | All synonyms accessible to the user |
| ALL_TABLES | Description of relational tables accessible
to the user |
| ALL_TAB_COLUMNS | Columns of user’s tables, views and clusters |
| ALL_TAB_COL_STATISTICS | Columns of user’s tables, views and clusters |
| ALL_TAB_COMMENTS | Comments on tables and views accessible
to the user |
| ALL_TRIGGERS | Triggers accessible to the current user |
| ALL_TRIGGER_COLS | Column usage in user’s triggers or in triggers
on user’s tables |
| ALL_TYPES | Description of types accessible to the user |
| ALL_UPDATABLE_COLUMNS | Description of all updatable columns |
| ALL_USERS | Information about all users of the database |
| ALL_VIEWS | Description of views accessible to the user |
| DATABASE_COMPATIBLE_LEVEL | Database compatible parameter set via init.ora |
| DBA_DB_LINKS | All database links in the database |
| DBA_ERRORS | Current errors on all stored objects in the database |
| DBA_OBJECTS | All objects in the database |
| DBA_ROLES | All Roles which exist in the database |
| DBA_ROLE_PRIVS | Roles granted to users and roles |
| DBA_SOURCE | Source of all stored objects in the database |
| DBA_TABLESPACES | Description of all tablespaces |
| DBA_TAB_PRIVS | All grants on objects in the database |
| DBA_TRIGGERS | All triggers in the database |
| DBA_TS_QUOTAS | Tablespace quotas for all users |
| DBA_USERS | Information about all users of the database |
| DBA_VIEWS | Description of all views in the database |
| DICTIONARY | Description of data dictionary tables and views |
| DICT_COLUMNS | Description of columns in data dictionary
tables and views |
| GLOBAL_NAME | global database name |
| NLS_DATABASE_PARAMETERS | Permanent NLS parameters of the database |
| NLS_INSTANCE_PARAMETERS | NLS parameters of the instance |
| NLS_SESSION_PARAMETERS | NLS parameters of the user session |
| PRODUCT_COMPONENT_VERSION | version and status information for
component products |
| ROLE_TAB_PRIVS | Table privileges granted to roles |
| SESSION_PRIVS | Privileges which the user currently has set |
| SESSION_ROLES | Roles which the user currently has enabled. |
| SYSTEM_PRIVILEGE_MAP | Description table for privilege type codes.
Maps privilege type numbers to type names |
| TABLE_PRIVILEGES | Grants on objects for which the user is the
grantor, grantee, owner, or an enabled role or PUBLIC is the grantee |
| TABLE_PRIVILEGE_MAP | Description table for privilege (auditing option)
type codes. Maps privilege (auditing option) type numbers to type names |
