Description:
Oracle database administration/server topics.
|
|
|
/oracle file system keeps growing
|
| |
I am on HP UNIX 11.23 using Oracle 11.7. My file system is 16GB and it is 95% full and keeps growing. I am however unable to find which file(s) are causing this problem.
I use find command:
Find . –mtime -2 –size +100 –print
I find all files which were modified in last 2 days whose size is greater than 100K and I do not see any.... more »
|
|
Can't see records in large table
|
| |
I consider myself pretty decent with Postgres and MySQL. But I'm really struggling with Oracle, clearly because the administration model is really different.
I've very little experience with Oracle. A week ago, I was given a 150GB Oracle dump and asked to import it into our MySQL (I know: horror) database.... more »
|
|
Virtual Databases
|
| |
I'm posting this discussion here, because of the moderator on one of the LinkedIn forums. The post that has probably irritated the moderator was the following:
"Nuno, everything is virtual these days. The mere word "virtual" sells things. With the advent of the little blue pill produced by Pfizer, even... more »
|
|
Very Urgent Required : BI and Reporting Technical Lead for Bahrain
|
| |
VAM SYSTEMS is a Business Consulting, IT Solutions and Services
company with operations in UAE, Qatar, Bahrain, USA, Australia,
Singapore & India.
VAM SYSTEMS is currently looking for BI and Reporting Technical Lead
for our Bahrain operations with the following skill set and terms and
conditions:... more »
|
|
Certain dynamic sql statements make stored procedures "forget" transaction?
|
| |
Hi
Pleae see the code below. The grant statement causes the stored
procedure to fail to roll back when raise_application_error is called.
(Presumably this is because the grant includes a commit?)
Is there a way to workaround this - that is rollback the changes in
the stored procedure when a subsequent exception is thrown after such... more »
|
|
seeding code into awr in 11g r2
|
| |
I was told last week that there was a method of ensuring ( via stored procedure ) that a specific sql_id can be seeded into awr.
Have scanned documentation without success so far
Please advise if this is possible
regards
Chris B
|
|
?????????? WHY DID PROPHET MUHAMMAD MARRY AISHA THE YOUNG GIRL
|
| |
WHY DID PROPHET MUHAMMAD MARRY AISHA THE YOUNG GIRL?
This is an important book talks about a common issue misunderstood but
misused by lots of thinkers and orientalists. It is “Why did Prophet
Muhammad marry Aisha the young girl?” The author shows the reason
behind their discussion. They want to distort the picture of Prophet... more »
|
|
Cheap Nike Air Max 2013 Shoes men's women's wholesale www.Buy-Good-Goods.com
|
| |
[link]
Buy Good Goods PayPal Payment Discount Cheap Price Free Shipping Wholesale Nike Shoes Jordan shoes,Ugg Boots,D&G Shoes,Gucci Shoes,Dsquared2 Shoes,Prada shoes,Hogan shoes,Shox NZ R4 shoes,Aidias shoes,Puma shoes,Timberland boots,jerseys,clothes,Moncler down Jackets,Canada Goose Down Jackets,t-shirts,jeans,underwe ar,handbags,belts,wallets,sung lasses,caps,watches,Monster headphones,iphone 5,Ipad4, Herve Leger Dress,Christian Louboutin shoes, ...... more »
|
|
NLS_LENGTH_SEMANTICS = CHAR import is too slow
|
| |
I am converting a database from its current character set WE8ISO88591 to AL32UTF8
I am using NLS_LENGTH_SEMANTICS to CHAR so I do not have to increase column lengths.
I follow Oracle instructions:
144808.1 313175.1 Except import which takes way too long.
I took a full export of WE8ISO8859p1 Database and now importing it in AL32UTF8.... more »
|
|
Weird procedure access problem (ORA-00942)
|
| |
Hi
User SSF can see and execute procedure SP_GET_SERVER, and has granted
execute access to user SSF_ADMIN1. However (sqlplus session as
SSF_ADMIN1):
SQL> select * from all_objects where object_name = 'SP_GET_SERVER' and
object_type = 'PROCEDURE';
OWNER OBJECT_NAME... more »
|
|
|