|
|
|
| | smb not working with Samsung Galaxy Tab 7.7 and Fritz!Box 7390
I had a weird problem while trying to access smb shares on my Windows XP computer from Samsung Galaxy Tab 7.7 with ES File Explorer, the router is Fritz!Box 7390. Tab 7.7 could see the smb server and the shares, however, when trying to click on a specific directory under ... | | More...
01/31/12 | | | | | | | | |
| | | When and what's been analyzed
select a.TABLE_NAME, a.PARTITION_NAME, a.SUBPARTITION_NAME, a.NUM_ROWS, a.SAMPLE_SIZE, a.LAST_ANALYZED, a.STATTYPE_LOCKED, a.STALE_STATS, b.MONITORING, b.TEMPORARY, c.default_directory_name
from dba_tab_statistics a, dba_tables b, dba_external_tables c
where a.owner = '[SCHEMA]'
and (a.owner = b.OWNER and a.TABLE_NAME = b.TABLE_NAME)
and (c.OWNER (+)= a.OWNER and c.TABLE_NAME (+)= a.TABLE_NAME)
order by a.LAST_ANALYZED asc; | | More...
10/11/11 | | | | | | | | |
| | | | | | | View Oracle database properties
To check database properties, for example: default tablespace type, various nls parameters, timezone etc run the following query:
SELECT *
FROM DATABASE_PROPERTIES; | | 
More...
02/01/11 | | | | | | | | |
| | | Find I/O intensive SQL statements
--
-- Determine the heaviest sql statements, sorted by disk reads and then by executions
--
SELECT executions, buffer_gets, disk_reads, first_load_time, sql_text
FROM v$sqlarea
ORDER BY disk_reads desc, executions desc; | | More...
01/25/11 | | | | | | | | |
| | |
|
