-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
Run the following SQL to find permissions granted on individual objects on the database select case when p.protecttype = 205… READ MORE
Using the following PL/SQL code one can find average size of a row in a table, the following code samples… READ MORE
|
Table structure in Oracle SQL> desc scott.oracletable; Name Null? Type —————————————– ——– ———- TRANSDATE NOT NULL DATE SEQUENCE_NO NOT NULL… READ MORE
|
If a SQL script file has blank lines in between SQL statements one may see errors when executing the script… READ MORE
|
SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON NAME TYPE VALUE ———————————— ———– —————————— sec_case_sensitive_logon boolean TRUE SQL> SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON =… READ MORE
Now Oracle has a quick way to find users with detault password. SQL> SELECT * FROM dba_users_with_defpwd; And here is… READ MORE
|
Sample program that demonstrates using JDBC to connect to Oracle database. Source code $ cat TestConnection.java import java.sql.*; public class… READ MORE
|
— print usernames and the roles assigned to the user, it can be run against any database and it will… READ MORE
|
Using dbms_lob.getlength(column name) one can find the length of the LOB (CLOB/BLOB/BFILE) data type. Example: SQL> SELECT dbms_lob.getlength(lob_column) FROM scott.lob_table;… READ MORE
Using ANALYZE TABLE owner.table_name COMPUTE STATISTICS one can find if the table has chained rows. Example: — analyze again SQL>… READ MORE
|
Using v$filestat one can find the physical reads and writes to datafiles it also includes reads done by RMAN. So… READ MORE
|
In 10g SMON gathers information on columns that are used in predicates and updates them in COL_USAGE$. Here is the… READ MORE
|
Using dbms_workload_repository.create_snapshot() one can create AWR snapshot. Example: Creates the snapshot and returns the snap id. If ‘ALL’ is not… READ MORE
— view to monitor space usage by different occupants and procedure to move the feature to a different tablespace. SQL>… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 